conditional formatting using two date columns
I use several date columns to track my project, for example, a start date, a finish date and an actual finish date. I want to apply conditional formatting so that if actual finish date is not equal to finish date, meaning a task can be finished ahead of schedule or a delay, then highlight that row. I tried conditional formatting and reports, but neither worked.
Any suggestions welcome!