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

Try a formula:

=if(left(a1,1)="v"
See:
http://www.officearticles.com/excel/...ft_ excel.htm

************
Hope it helps!
Anne Troy
www.OfficeArticles.com

"Coltsfan" wrote in
message ...

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