conditional formatting

  • Thread starter Thread starter mariekek5
  • Start date Start date
M

mariekek5

HI,

If I want more then 3 text values to be yellow for instance... Is that
possible. Because I can only add three.... but I think maybe its possible to
add more than one criterium per box...

If I want "V" and "X" and "C" to become yellow...

Can I put that in one box?

Something like..

="V";"X";"C" ...

Hope someone can help.

Thanks in advace
 
Select ColumnA. For Condition1>Select 'Formula Is' and enter the below formula

=OR(A1="V",A1="X",A1="C")

Alternatively; if you have more words..you can create a named range and try
the below formula
=COUNTIF(keywords,A1)>0


If this post helps click Yes
 
actually, I want it in a bogger area....not just one column....

Is it also possible then?!
 
Thats'fine. Select the area you would like to apply the formatting.

Say if the range is C10:H30 refer the starting range in the formula
like =OR(C10="V",C10="X",C10="C")

If this post helps click Yes
 
Its strange, because when I do exactly what you tell me....the cells I want
to be yellow stay normal, whereas the cells I want to be normal, become
yellow....
 
Back
Top