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.
=WEEKDAY(A2,2)>5
Apply red font
regards, barry