Conditional Formatting for Blank Cells

  • Thread starter Thread starter robert
  • Start date Start date
R

robert

I am using the Datatransfer add-in against an AS/400
mainframe query and want to conditionally format cells
that the query returns as blanks.

When I go to format/conditional formatting and set
formula is, then isblank(A:A) and select formatting, I
get no cell formats.

What am I doing wrong?

Thanks,
Robert
 
Robert

Select all Column A or an appropriate range down Column A then
Format>CF>Formula is:

=ISBLANK(A1)

Note the Relative References for A1

Gord Dibben XL2002
 
Back
Top