Conditional Format

[nbslarson]

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.

 

[DoctorG]

You can use the or function

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

 

[nbslarson]

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

 

[Pete_UK]

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

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

Hope this helps.

Pete

 

[DoctorG]

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.

 

[DoctorG]

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.