Show blank cells as red with conditional formatting

[bmac]

Hello, what formula can I use with the conditional formatting dialog to show
cells that are empty as the color red.

Thanks in advance

bartmacl

 

[RagDyer]

Click "Formula Is", and enter this:

=A1=""

And set your format.


HTH,

RD

 

[Frank Kabel]

Hi
use the formula
=ISBLANK(A1)
if cell A1 is your cell to check

 

[Trevor Shuttleworth]

Formula is: =A1=""

assuming the selected cells start in cell A1

Regards

Trevor

 

[bmac]

Thanks very much!

Click "Formula Is", and enter this:

=A1=""

And set your format.


HTH,

RD

 

[bmac]

Thanks very much.

Hi
use the formula
=ISBLANK(A1)
if cell A1 is your cell to check

 

[bmac]

Thanks very much.

Formula is: =A1=""

assuming the selected cells start in cell A1

Regards

Trevor