View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jarek Kujawa[_2_] Jarek Kujawa[_2_] is offline
external usenet poster
 
Posts: 896
Default Conditional formatting Q

say you have yr data in A1, then in conditional formatting window
select FormulaIs and insert:

=OR(A1="a",A1="b",A1="c",A1="d")

choose red color

then copy, paste formats