Conditional Formating-get to do 3 options

[Coltsfan]

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

[Anne Troy]

Try a formula:

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

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

"Coltsfan" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>

[pinmaster]

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]

Thank you it worked

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
>
>