If day = mon then background =

Posted by John on October 08, 2000 4:27 AM

I would like to have excel automatically change the background of cells on certain days to show when they have changed. The statement would be IF today = mon or thursday then background color = . I would also need the statement to say IF today = monday or thursday then range a1 to z100 replace background color yellow with green. Thanks

Posted by Celia on October 08, 2000 4:56 AM

John
Select the cells you want highlighted and go to Conditional Formatting. In the FormulaIs box put the following formula in respect of Monday :-
=IF(WEEKDAY(NOW())=2,TRUE,FALSE)
and set the cell colour you want.
For the second criterion, use the following formula re Thursday :-
=IF(WEEKDAY(NOW())=5,TRUE,FALSE)

Celia