Conditional Formatting - Target Dates vs Actual Dates

Cliffinkent

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

 

JamesR

Cliff,

=IF(Finish2 > Baseline2, 1, 0)

Change the Formula 1,0 not 1,1

James

Cliffinkent

Hey, 

 

Thanks James, that plus a rejig of my columns fixed it!

 

Cliff