Conditional formating -identify blank cell
 

Looking for a way to indicate if a range of cells contains a blank cell.
Tried to use conditional formating to change A1 to a red font if any cell in
the range b1-z1 is blank. Can't seem to get conditional formatting to work,
any ideas?

Thanks

Conditional formating -identify blank cell
 

Try this for your Conditional Formatting formula in A1:

=COUNTIF(B1:Z1,"")0

HTH,
Elkar


"Simon Smith" wrote:

Looking for a way to indicate if a range of cells contains a blank cell.
Tried to use conditional formating to change A1 to a red font if any cell in
the range b1-z1 is blank. Can't seem to get conditional formatting to work,
any ideas?

Thanks

Conditional formating -identify blank cell
 

Condition 1 Formula is =COUNTA($B1:$Z1)<25

Select the format you want font = red

Regards

Trevor


"Simon Smith" <Simon wrote in message
...
Looking for a way to indicate if a range of cells contains a blank cell.
Tried to use conditional formating to change A1 to a red font if any cell
in
the range b1-z1 is blank. Can't seem to get conditional formatting to
work,
any ideas?

Thanks

Conditional formating -identify blank cell
 

Hi!

Select cell A1
Goto FormatConditional Formatting
Formula is: =COUNTBLANK(B1:Z1)
Click the Format button
Select the style(s) desired
OK out

Biff

"Simon Smith" <Simon wrote in message
...
Looking for a way to indicate if a range of cells contains a blank cell.
Tried to use conditional formating to change A1 to a red font if any cell
in
the range b1-z1 is blank. Can't seem to get conditional formatting to
work,
any ideas?

Thanks