Conditional Formattting

S

Steve

I'd like to know if Excel will apply conditional formatting to a value if it falls within a range of values or named range. Specifically, I'd like to change the color of the cell to various colors based on which group or named range the initials of the person contained in that cell fall. Example: Group1 contains the initials KR, KM, Group 2 contains SE, PK. I'd like the conditional formatting to change the color of cells based on whether the initials contianed within that cell belong to Group1 or Group2. If I enter the initials KR into a cell, I'd like that cell to be green. If I enter SE, I'd like the cell to be blue. Make sense?
 
B

Bob Phillips

use formulae of

=OR(A1="KR",A1="KM")

and

=OR(A1="SE",A1="PK")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Steve said:
I'd like to know if Excel will apply conditional formatting to a value if
Click to expand...
it falls within a range of values or named range. Specifically, I'd like to
change the color of the cell to various colors based on which group or named
range the initials of the person contained in that cell fall. Example:
Group1 contains the initials KR, KM, Group 2 contains SE, PK. I'd like the
conditional formatting to change the color of cells based on whether the
initials contianed within that cell belong to Group1 or Group2. If I enter
the initials KR into a cell, I'd like that cell to be green. If I enter SE,
I'd like the cell to be blue. Make sense?
 
S

Steve

Thanks. I tried those formulae previously to no avail, but after your post, I tried it specifying "Formula Is" instead of "Cell Value Is," which is what I had been using. Voila!
 
B

Bob Phillips

Sorry, I had assume that, but I should have been explicit.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Steve said:
Thanks. I tried those formulae previously to no avail, but after your
Click to expand...
post, I tried it specifying "Formula Is" instead of "Cell Value Is," which
is what I had been using. Voila!
 
Top