View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SandyB SandyB is offline
external usenet poster
 
Posts: 7
Default conditional formatting OR formula

=OR(C:C="FLAT",C:C ="2FS",C:C ="3FCH")

Above is the formula I am trying, so column C words Flat, 2FS, or 3FCH will
get yellow highlight in another column cell. However, it now highlights the
entire column yellow, regardless of the text I have in column C. What am I
doing wrong?
--
SandyB