Conditional Formatting for another cell containing specific text

Hi dropanddrive, and welcome to the forum

Actually looking for any "day" name would not work for you there, because the cell entries are dates, whis is a special form of number/value. So the cells cont actually contain "Saturday" or "Sunday", they are just formatted to look like they do

1. highlight the range you want to apply the conditional formatting to
2. on the home tab, styles, select CF
3. select new rule, select use formula
4. enter =WEEKDAY($A5,2)>5 format fill as required.

Hope that helped?

If the cells actually did contain text, and 1 of the words was Saturday, you could use something like this to test for it...
=ISNUMBER(SEARCH("Saturday",A5,1))

Try this in CF of B5 :
=OR(WEEKDAY($A5)=7,WEEKDAY($A5)=1)
set to all cells in range

@ bebo, if you set up the weekday() function using ,2, you can simplify the test to what I suggested in #2

Yep that 's a good tip. If printing out, we can save a lot of ink...
Anyway, I've watched carefully to make sure that you were not around here before posting...

Make sure you high-light the entire range A5:D35 (or B5:D35 if you still want the dates shown) before you go into CF

then make sure you select USE FORMULA and either type exactly, or copy paste my formula into the CF formula bar.

to explain the formula =WEEKDAY($A5,2)>5...

=weekday($A5,2) is checking A5 to see what day of the week it is. there are a few arguments that come with this function, using ,2 sets Monday as 1 and Sunday as 7. This lets me then test for any weekday number >5...Sat=6, Sun=7
the $ is absoluting column A so that it will always be the column referenced

If you still have a problem, let me know and I will upload your (modified) file for you

Happy to help, and thanks for the feedback