| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
alternate row shading on filtered data
For ease in reading a printed spreadsheet with many rows, I want to use
alternate row shading. However, I also use the auto filter to show only rows that have a value greater than zero in a particular column. That ruins the alternate row shading. Is there some sort of formula I can use to have alternate row shading AFTER the filtering? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Alternate Row Shading (Visible Rows Only) | Excel Worksheet Functions | |||
| How do I set up alternate row shading with Excel 2003? | Excel Discussion (Misc queries) | |||
| Alternate row shading with a filtered spreadsheet | Excel Discussion (Misc queries) | |||
| Alternate shading colors | Excel Discussion (Misc queries) | |||
| Alternate Shading | Excel Discussion (Misc queries) | |||
Threaded Mode
