View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Saintsman Saintsman is offline
external usenet poster
 
Posts: 81
Default Conditional formatting and IF

How can I turn a condition off or on?

If current cell has a value then the format is white font, blue background
.....if cell A1 = "yes"

If current cell has a value then the format is blue font, blue background
.....if cell A1 = "no"

Format is white font, white background if no value