Is there a way to use a conditional format which will color a cell one way if
the value is either "VIP" or "Prem"?
I have conditional formats in condition 1 and condition 2, and this would be
condition 3.

You can use the or function

i.e. =or(a1="VIP";a1="Prem")

"nbslarson" wrote:

Is there a way to use a conditional format which will color a cell one way if
the value is either "VIP" or "Prem"?
I have conditional formats in condition 1 and condition 2, and this would be
condition 3.

Doctor G, I tried that, but I keep getting an error, and the "VIP" is
highlighted in the error,

"DoctorG" wrote:

You can use the or function

i.e. =or(a1="VIP";a1="Prem")

"nbslarson" wrote:

Is there a way to use a conditional format which will color a cell one way if
the value is either "VIP" or "Prem"?
I have conditional formats in condition 1 and condition 2, and this would be
condition 3.

You probably need to use a comma rather than a semicolon:

=or(a1="VIP",a1="Prem")

Hope this helps.

Pete

On Feb 12, 6:47*pm, nbslarson
wrote:
Doctor G, I tried that, but I keep getting an error, and the "VIP" is
highlighted in the error,



"DoctorG" wrote:
You can use the or function

i.e. =or(a1="VIP";a1="Prem")

"nbslarson" wrote:

Is there a way to use a conditional format which will color a cell one way if
the value is either "VIP" or "Prem"?
I have conditional formats in condition 1 and condition 2, and this would be
condition 3.- Hide quoted text -

- Show quoted text -

Why don't you try it first in a worksheet cell.

Put
=or(a1="VIP";a1="Prem")
in cell A2 and try different inputs in A1.

Maybe something is written wrong. Do you use all of the quotes? Maybe
something is wrong with the ";".

You can also try it with just one argument, like =or(A1="VIP")

If this succeeds see if your language settings require a different character
to join the arguments instead of ";".

See if this helps.

"nbslarson" wrote:

Doctor G, I tried that, but I keep getting an error, and the "VIP" is
highlighted in the error,

"DoctorG" wrote:

You can use the or function

i.e. =or(a1="VIP";a1="Prem")

"nbslarson" wrote:

Is there a way to use a conditional format which will color a cell one way if
the value is either "VIP" or "Prem"?
I have conditional formats in condition 1 and condition 2, and this would be
condition 3.

I am sorry about the inconvenience I may have caused. My regional settings
require me to use a semicolon instead of a comma when entering a formula in a
cell and a comma when writing VBA. What a mixup....

Anyway, I believe we have helped nbslarson with his problem although I
cannot see any green checks beside any of our answers.

"nbslarson" wrote:

Doctor G, I tried that, but I keep getting an error, and the "VIP" is
highlighted in the error,

"DoctorG" wrote:

You can use the or function

i.e. =or(a1="VIP";a1="Prem")

"nbslarson" wrote:

Is there a way to use a conditional format which will color a cell one way if
the value is either "VIP" or "Prem"?
I have conditional formats in condition 1 and condition 2, and this would be
condition 3.