Share via

when shading is applied to every other row, how do I keep the shading from the row above when inserting a new row?

Anonymous
2024-08-08T20:51:46+00:00

when shading is applied to every other row, how do I keep the shading from the row above when inserting a new row?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Rich~M 20,370 Reputation points Volunteer Moderator
    2024-08-08T21:50:17+00:00

    You can use Conditional Formatting to apply the shading rather than manually coloring the rows.

    1. remove any manual shading that has been applied.
    2. Select the range of cells that you want to shade or select the rows to shade. (Best to select a range because if rows are selected Excel will apply the formatting all the way across all of the columns.)
    3. On the Home ribbon in the Styles section select Conditional Formatting>New Rule>Use a Formula. In the Format Values line enter this formula.

    =ISEVEN(ROW())

    1. Click on the Format button at the lower right and in the Format Cells dialogue choose the desired formatting. Click OK and OK.

    2 people found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest