Change cell color if date exceeds formula
 

Hi,

I want to be able to change the cell color from a default (say green) to red
when a date is past the date range specified. ie a cell would red todays date
and then the adjacent cell would have a IF formula that would specify a date
(say 14 days) after the first date. The cell would be green but when those 14
days are up they would change to red. I know it can be done... but how !
thanks

Change cell color if date exceeds formula
 

I don't quite understand which cells you want to change but how about some
conditional formatting along the lines of - cell value is greater then
=today()+14 and set the format to red
--
John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)


"Harry K" wrote:

Hi,

I want to be able to change the cell color from a default (say green) to red
when a date is past the date range specified. ie a cell would red todays date
and then the adjacent cell would have a IF formula that would specify a date
(say 14 days) after the first date. The cell would be green but when those 14
days are up they would change to red. I know it can be done... but how !
thanks