Conditional format -blank

S

Simon Smith

Can't get the conditonal format function to work such that A1 is a red font
if b1 through z1 is blank.
Just looking for an easy way to identify if theres an emply cell on a row
without scrolling.

Any ideas
 
G

Guest

Select A1 and in your CF box use: Formula is and then
=ISBLANK(B1:Z1)
and set your format.

Andy.
 
B

Biff

Hi!
=ISBLANK(B1:Z1)
Click to expand...

That will only apply to cell B1. Try:

=OR(ISBLANK(A1:Z1))

But ISBLANK will not recognize formula blanks "" as blank cells. If you want
to account for formula blanks try:

=COUNTBLANK(A1:Z1)

Biff
 
P

Powlaz

Andy and Bif,

Thanks for the fast replies. Both formulas returned the same results (best
as I can tell). I'd like to understand a little more about what they are
doing if you'll be kind enough to explain.

But before that, I'm still stuck with a problem. My range (b6:b12) is blank
until data is entered. I'm trying to avoid a "0" showing up in b13 where the
total value of b6:b12 is calculated. Furthermore, I don't even want a total
to calculate in b13 until each field in b6:b12 is filled in with a 0 or
greater.

Both of your formulas returned a value of 0 even though b6:b12 were blank.

Could using =ISBLANK for the range fix my problem?

PO
 
Top