Conditional Formatting with DDDD (Day of Week Name) Formatted Cells

[BrooksTech]

Im having a lot of trouble with a 97-2003 XLS Worksheet where Column C is custom-formatted 'dddd' with a formula =A2 where Column A contains dates. I want the entire row to highlight if the DAY in C is a Tuesday or Thursday. I selected "Use a formula" option and a sample formula entered is =$C2="Tuesday" and then added another separate rule =$C2="Thursday"

Then I went on and copied the formats of this row onto all the other affected rows with NO results. Neither rule worked. Ive had quite a lot of experience conditional formatting except with this dddd type.

I dont know if the fact that dddd is formatted different than standard-text or some other hidden factor, but Ive been formatting cells in other ways and never had NO result.

 

[Jonmo1]

If A2 is formatted as dddd, and shows Tuesday or whatever...
That cell still actually contains the Date, Not the Text String of Tuesday..

In conditional formatting, you would have to do the same thing the formatting does, to pull out the word for the day..

Try
=TEXT($C2,"dddd")="Tuesday"

Or also
=WEEKDAY($C2)=3

 

[BrooksTech]

Yes, thank you it worked. Now Im having problems filtering because it still sees a date, not day. I want to only show rows with a Tuesday or Thursday. Sorry Im stubborn, I dont want to filter by color if I can help it. Thanks again.

 

[Jonmo1]

Put in a helper column with the formula

=TEXT($C2,"dddd")

Then you can filter on that column (as well as base the conditional format on that column)

 

[SittingDuck]

I found this information very useful. I used the
=TEXT($C2,"dddd")="Tuesday"
example
but what do you put in for the formula if you want to put in multiple days? ="Mon" "Wed" "Fri"
Im totally new to excel cant figure our this problem.

 

[Jonmo1]

You could do

=OR(TEXT($C2,"ddd")="Mon",TEXT($C2,"ddd")="Wed",TEXT($C2,"ddd")="Fri")