G
Guest
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
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