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?

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?

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?

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

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