Need a shaded row in Excel that doesn't move as data changes

C

czr

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.
 
K

Ken Johnson

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
 
Top