Highlighting only cells with data in them

  • Thread starter Thread starter Ian M
  • Start date Start date
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
 
Maybe standard conditional formating?


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

Condition 2:

=1:1="" and give another format

HTH Sige
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlight Cells in Active Row 5
Code to identify whether a cell has manual highlighting or not 5
Macros in Excel 2003 7
highlight row 4
Highlight row and insert text on click 3
Look up match and highlight 1
If Then or Case help 3
Macro to select / highlight entire row. 5

Back
Top