Highlighting only cells with data in them
 

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

Highlighting only cells with data in them
 

Maybe standard conditional formating?


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

Condition 2:

=1:1="" and give another format

HTH Sige


-----Original Message-----
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
.