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.
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.