Conditional Formating

[proficient]

Hi All,

I am here to ask you that let say if I have a table range A1:K10, all the cells housing dates, what I want to do is that if any cell have a SUNDAY the cell auto highlighted in red... please advise the formula...

 

[FormR]

Like this:

=WEEKDAY(A1)=7

 

[proficient]

I have selected the whole range and type your given formula in conditional formating but nothing is changed...

 

[FormR]

Maybe there are no Sundays in the range or maybe your dates are text values that look like dates.

You can test if they dates are real Excel dates by using the formula =ISNUMBER(A1) which should return TRUE.

 

[pgc01]

Hi

It should be

=WEEKDAY(A1)=1

 

[FormR]

Hi

It should be

=WEEKDAY(A1)=1

Of course!

 

[proficient]

Still not working... Do you have any idea why...?

 

[pgc01]

It works for me.

Please you post how you are setting it up, step by step.

 

[proficient]

I have a range from L6:Q12

First I have selected the whole range then go to "NEW RULE" in C.F, clicked on "Use a formula to determine which cells to format" then type your given formula (Replace A1 with L6) then selected the color from format and hit the enter... Please tell where I am doing wrong...?

 

[witsonjoyet]

hai,
select the range and go to conditional format - new rule and use

=+WEEKDAY($A1,1)=1

Regards
witson