View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
 
Posts: 8,520
Default conditional formatting

Select ColumnA. For Condition1Select '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
---------------
Jacob Skaria


"mariekek5" wrote:

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