View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
pinmaster
 
Posts: n/a
Default Conditional Formating

Another way:

=OR(A1="v",A1="v1",A1="v2")

HTH
JG


"Coltsfan" wrote:


Probably a simple question but I don't deal with this that much. In
Conditional Formating you only get to do 3 options. I was wondering if
on one of them you could have multiple.

Example:

My first one says if "x" then blue
My Second one says if "l" then pink
but on my third one, I want it to say if "v" "v1" or "v2" then green.

Any ideas??? thanks in advance


--
Coltsfan
------------------------------------------------------------------------
Coltsfan's Profile: http://www.excelforum.com/member.php...o&userid=19982
View this thread: http://www.excelforum.com/showthread...hreadid=501838