Cond Formatting

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

Hiya,

I'm in cell G5 which is where I have "S" for Saturday, the next cell is "S"
for Sunday etc....

1) What I would like to do his put a shade of grey in the column starting
at G7 to say G120, and then I'd obviously copy it to the remainder of the
"S's."

2) I also have other CF in that column, such as if "W" is entered it
changes to a green background (but no CF in G5), will one over ride the
other, and or will there be a conflict... that is once I learn how to do
question one.... :-)

Thank you,

P.S. I like this newsgroup, it gets the mind going and exploration
begins.... woohooo
 
Hi

You can have up to three conditions using CF. Each one is tested in the
order they are displayed so mixing them is not a problem.
In your range you can use
Cell Value is equal to S (and colour it grey)
for condition 1 and
Cell Value is equal to W (and colour it green)
for condition 2

Have a look here for some information on CF:
http://www.contextures.com/xlCondFormat01.html
 
Thanks for you help. I already had mixed out my CF on those cells, mind you
I never thought of doing it your way, it just worked out good for me I
guess. I hope excel adds more options for CF next time around.

Thank you.
 
Back
Top