can I configure Conditional formatting to change color weekly?
 

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?

can I configure Conditional formatting to change color weekly?
 

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

"Joe" wrote in message
oups.com...
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?

can I configure Conditional formatting to change color weekly?
 

Try:

Select your cell and in CF:

FormulaIs: =weekday(Today(),2)=1 and set colour

"Joe" wrote:

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?

can I configure Conditional formatting to change color weekly?
 

On Feb 21, 2:52 pm, Toppers wrote:
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

can I configure Conditional formatting to change color weekly?
 

NO ...=WEEKDAY(Today(),2)=3

the 2 signifies that Monday=1, Sunday=7

Look at WEEKDAY function HELP.

"Joe" wrote:

On Feb 21, 2:52 pm, Toppers wrote:
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