Conditional Formatting referencing a formula, but looking for text

[jme1013]

Hi all,

I've got a spreadsheet that I print every week that has the current week by date and day on it. When I open the spreadsheet it automatically updates the dates of the week to populate, starting with the Sunday of the current week. I have the date starting in Cell B4. Above it in Cell B3 I have the day of the week (Sunday, Monday,...) auto populating by referencing B4. I have it set up this way as sort of a check to make sure the dates are correct, the first day should always be Sunday.

All of that works fine. The problem I'm having, I want the Cell that is supposed to say Sunday in B3 to turn Red if the date in B4 is incorrect (causing B3 to display something other than Sunday). I've tried several different ways with conditional formatting to no avail. I'm assuming it's because in my condition I'm stating "if B3 is not = to "Sunday" fill red. The problem is Sunday is a date format, and I'm telling it to look for the Text "Sunday".

I'm not sure of the best way to solve this.

Thanks in advance for any help.

[JBeaucaire]

Use this CF formula:

=WEEKDAY(B4)<>1

[jme1013]

That formula works but doesn't accomplish what I'm shooting for. I want the cell to return the actual day of the week and if it does not say Sunday I want to use conditional formatting to turn the cell red. Using that formula still causes the cell to be in a date format when the conditional formatting is looking for Text (I think).

[JBeaucaire]

No, leave your existing formula in B3, probably just =B4 and then formatted to use number format DDDD.

Then use the formula I gave you as the Conditional Formatting (CF) formula you use on B3 to turn it red. (if needed)

[jme1013]

Perfect Sir. Sorry, I was a little slow on the uptake!