Posted to microsoft.public.excel.misc
|
|
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
|