Hey guys & gals
Basically I'm trying to get my actual task finish date to highlight green or red if it hits or doesn't hit the target date.
I know I need a checkbox column to do this. I've added one with the following formula
=IF(Finish2 > Baseline2, 1, 1)
Finish2 = the first cell with the actual finish date
Baseline2 = the first cell with the target finish date
The formula should tick the box if the finish date is greater than the target date.
However it ticks the box is the finish date is greater than OR Equal to target.
What am I doing wrong?
Thanks for your help
