View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
DoctorG DoctorG is offline
external usenet poster
 
Posts: 106
Default Conditional Format

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.