Conditional Formatting for Blank Cells

[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

 

[Gord Dibben]

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