|
In response to
"Excel question: I have some cells with text in them. A list. I have another column next to that list."
by
sycor
|
with A1, click conditional formatting -> new rule ...
Posted by
zork
May 20 '15, 10:00
|
select "Use a formula ..."
in the box "Format values where ..."
=b1="sycor" <---- make sure it's not $B$1
click format and select font colour, background, bold, etc. as needed
add more rules to A1 for each value in column B that you want to cover, each time referring to B1 in the formula.
When all rules have been added, with A1, click Format Painter button and then select column A.
|