Highlighting only cells with data in them

I

Ian M

In an Excel Spreadsheet, I wish to highlight all the rows and columns
which contain data, however these change every time I access the File.

Is there any way I can highlight ONLY those rows and columns which
contain data?

Any ideas?

Many thanks.

Ian M
 
S

sige

Maybe standard conditional formating?


Condition 1:
=1:1<>"" and give the format you want

Condition 2:

=1:1="" and give another format

HTH Sige
 
Top