# Using Conditional Formatting (Formula Is)

#### Chris The Rock

##### Active Member
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?

### Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
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

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

Thanks very much!

Replies
7
Views
209
Replies
1
Views
77
Replies
1
Views
120
Replies
5
Views
181
Replies
9
Views
287

1,219,580
Messages
6,149,109
Members
450,861
Latest member
metcala

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back