Cond Formatting

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
 
A

Andy B

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
 
K

Kevin

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.
 
Top