Solved

# Excel conditional formatting formula for cell containing

Posted on 2011-10-18

I have an Excel spreadsheet that I tried to use conditional formatting. I am using a formula for this as opposed to the preset of finding cells containing something. I never could get that one to work. But I'm having a hard time using a formula for some reason. Here is what I'm trying to do:

assume I have a big column of dates in basically the following format:

Saturday October 1, 2011

Sunday, October 2, 2011

Monday, October 3, 2011

I want the Saturday and Sunday date cells to be changed to red type, while the Monday cell would be changed or (or should I really say) left as a black type.

With conditional formatting they do have an option to select cells containing. But whereas sites-Saturday nothing happens and I'm not sure why. That's why I tried a formula but I could not figure out a symbol to use in a formula for a cell that contains a text string.

Appreciate any help in this as I'm sure it is easy, but I'm having difficulty with it.