J
Joe
I have a cell I'd like to change color every Monday as an alert to a
task is there a way I can do this using conditional formatting?
task is there a way I can do this using conditional formatting?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
T
T. Valko
Try this:
Conditional Formatting
Formula Is: =WEEKDAY(TODAY(),2)=1
Set the format of your choice
Every Monday the format will change to what you set. If today is not Monday,
no format is set.
Biff
Conditional Formatting
Formula Is: =WEEKDAY(TODAY(),2)=1
Set the format of your choice
Every Monday the format will change to what you set. If today is not Monday,
no format is set.
Biff
T
Toppers
Try:
Select your cell and in CF:
FormulaIs: =weekday(Today(),2)=1 and set colour
Select your cell and in CF:
FormulaIs: =weekday(Today(),2)=1 and set colour
J
Joe
Try:
Select your cell and in CF:
FormulaIs: =weekday(Today(),2)=1 and set colour
Thanks to both of you, so am I to assume that if I want to change the
day to Wednesday it would be =weekday(Today(),4)=1
T
Toppers
NO ...=WEEKDAY(Today(),2)=3
the 2 signifies that Monday=1, Sunday=7
Look at WEEKDAY function HELP.
the 2 signifies that Monday=1, Sunday=7
Look at WEEKDAY function HELP.