| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highlighting cells being updated/new data being inputted. | Excel Discussion (Misc queries) | |||
| finding data entry required cells by highlighting. | Excel Discussion (Misc queries) | |||
| Highlighting cells | Excel Discussion (Misc queries) | |||
| Highlighting Cells | Excel Worksheet Functions | |||
| Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
Hybrid Mode
