Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating
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 |
#2
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formating
Thank you it worked pinmaster Wrote: 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 -- Coltsfan ------------------------------------------------------------------------ Coltsfan's Profile: http://www.excelforum.com/member.php...o&userid=19982 View this thread: http://www.excelforum.com/showthread...hreadid=501838 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional formating using formulas | Excel Worksheet Functions | |||
can i freeze conditional formating to copy to another worksheet | Excel Discussion (Misc queries) | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
more than 3 conditional formating in excel | Excel Discussion (Misc queries) |