Show blank cells as red with conditional formatting

bmac · Jun 14, 2004

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 · Jun 14, 2004

Click "Formula Is", and enter this:

=A1=""

And set your format.

HTH,

RD

Frank Kabel · Jun 14, 2004

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

Trevor Shuttleworth · Jun 14, 2004

Formula is: =A1=""

assuming the selected cells start in cell A1

Regards

Trevor

bmac · Jun 15, 2004

Thanks very much!

RagDyer said:
Click "Formula Is", and enter this:

=A1=""

And set your format.

HTH,

RD

bmac · Jun 15, 2004

Thanks very much.

Frank Kabel said:
Hi
use the formula
=ISBLANK(A1)
if cell A1 is your cell to check

bmac · Jun 15, 2004

Thanks very much.

Trevor Shuttleworth said:
Formula is: =A1=""

assuming the selected cells start in cell A1

Regards

Trevor