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

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

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

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