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
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
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
Condition 1 Formula is =COUNTA($B1:$Z1)<>25
Select the format you want font = red
Regards
Trevor
"Simon Smith" <Simon [email protected]> wrote in message
news:[email protected]...
> 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
Hi!
Select cell A1
Goto Format>Conditional Formatting
Formula is: =COUNTBLANK(B1:Z1)
Click the Format button
Select the style(s) desired
OK out
Biff
"Simon Smith" <Simon [email protected]> wrote in message
news:[email protected]...
> 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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks