Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a shaded row in Excel that doesn't move as data changes
How do I get a shaded row on an Excel worksheet that does not move? I know
how to shade a row, but each time the data filters, the shading moves with the data. I need specific rows to maintain their shading as the data changes. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a shaded row in Excel that doesn't move as data changes
You could use conditional formatting.
If row 10 is to be shaded select the row 10 cells, then in the Formula Is box of the conditional formatting dialog use... =ROW()=10 Ken Johnson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
How do I import formmail data to a custom excel template? | Excel Worksheet Functions | |||
Linking the data from one excel to another | Excel Discussion (Misc queries) | |||
How can deleted data reappear in a refreshed pivot table in Excel | Excel Discussion (Misc queries) |