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

Conditional formatting and IF
 

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

"Saintsman" wrote in message
...
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

Conditional formatting and IF
 

Go to FormatConditional 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)

"Saintsman" wrote in message
...
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