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

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

EXCEL FORMATTING OF WORKSHEETS WITH WITH SHADED ROWS 3
Shading Rows With IF Statements? 5
Conditional Formatting in Excel when data changes 0
Shading rows 2
sort 2
Shading a cell relative to three other cells & repeat 3
Shading alternate "groups" of rows? 10
Cell Shading 2

Top