Conditional formatting
 

I've got a column set to change color if it exceeds todays date (late),
but I need another one that cancels that if the next column (finished
date) is done on time. Right now even if the job is done on time when
the due date equals todays date it turns red.


--
gargoyle
------------------------------------------------------------------------
gargoyle's Profile: http://www.excelforum.com/member.php...o&userid=37121
View this thread: http://www.excelforum.com/showthread...hreadid=570289

Conditional formatting
 

your second conditional formatting formula should reinstate the original
colour, or you could make your original formula cater for it - give us
your formula to look at please


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=570289

Conditional formatting
 

Cell value is Less than =today()


--
gargoyle
------------------------------------------------------------------------
gargoyle's Profile: http://www.excelforum.com/member.php...o&userid=37121
View this thread: http://www.excelforum.com/showthread...hreadid=570289