Using Conditional Formatting (Formula Is)

[Chris The Rock]

I'm having a tough time getting this to work.

I have several cells in a row that I'd like to have a certain format IF the WEEKDAY of the cell in column A = 1 (SUNDAY).

How can I create a true/false formula that will work with Conditional Formatting?

 

[Aladin Akyurek]

On 2002-08-29 09:53, Chris The Rock wrote:
I'm having a tough time getting this to work.

I have several cells in a row that I'd like to have a certain format IF the WEEKDAY of the cell in column A = 1 (SUNDAY).

How can I create a true/false formula that will work with Conditional Formatting?

If A houses true dates, then I think you can use:

=WEEKDAY($A1)=1

 

[Chris The Rock]

I must have tried every other possible variation on that theme! I can't believe I missed it. How simple.

Thanks very much!