Conditional formatting and IF

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Dont understand the question. which cell is current, what's in A1 and in
which cell you need this formatting?
 
Go to Format>Conditional Formatting, click Delete, tick all conditions, and
OK out.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Back
Top