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.