| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highting rows based on content of cells
Hi there,
I have a document that I update regularly. Various rows have to be hidden at the end of the process. These rows are different every day, numerous and not contiguous. I thought I could put a specific word in the first cell of every row, then find a way to get Excel to highlight all those rows, then hide them all in one go, probably using a macro. I can't work out how to make the content of a cell result in that row being highlighted from the row header. Any thoughts?? Thanks! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Highting rows based on content of cells
Hi Sarah
Maybe you like EasyFilter Very easy with this add-in http://www.rondebruin.nl/easyfilter.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Sarah" wrote in message ... Hi there, I have a document that I update regularly. Various rows have to be hidden at the end of the process. These rows are different every day, numerous and not contiguous. I thought I could put a specific word in the first cell of every row, then find a way to get Excel to highlight all those rows, then hide them all in one go, probably using a macro. I can't work out how to make the content of a cell result in that row being highlighted from the row header. Any thoughts?? Thanks! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy rows to new sheet based cell reference, not value | Excel Discussion (Misc queries) | |||
| Copy rows of one sheet into mutiple sheets based on column value | Excel Discussion (Misc queries) | |||
| Calculating only non-empty cells... | Excel Worksheet Functions | |||
| Adding a subset of rows of cells, SUM, based on Lookup | Excel Discussion (Misc queries) | |||
| Put an autoshape in a cell based on another cells content | Excel Worksheet Functions | |||
Linear Mode
