Excel conditional format help.

[Colbaker]

Hi all,

Firstly imagine I have 3 columns of dates, cell A1 has start date in, B1 has requested end date, C1 has actual end date, what I am wanting to do is highlight cell C1 green if the date is on or before B1's date and C1 to turn red if the date entered is after the date entered in B1.

I assume it would be some sort of IF statement in the conditional format but can't seem to get it.....please help.

 

[Colbaker]

Just set up 2 rules based on formula in conditional formating

obviously change for your <= bit

That worked brilliantly thanks.

One last thing though, how do I get it so the cell stays blank if it is empty because at the moment it is green?