Conditional formatting and IF

[Saintsman]

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

 

[Gary]

Dont understand the question. which cell is current, what's in A1 and in
which cell you need this formatting?

 

[Bob Phillips]

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)