CODEWITHSUNDEEP
excel
user1322720
user1322720

Reputation:

Different background colors for even and odd rows

How can I set up a column in Excel so that every other line has a different background color, even when I insert a new row?

Upvotes: 0

Views: 3427

Answers (2)

jroussin007
jroussin007

Reputation: 98

Creating a table is one way to do that.

Select the cells that should have the alternating color formatting, click "Insert" and "Table" on the ribbon. Tell Excel whether your data has a header row, and click ok.

If you would prefer to clear the arrow that appears on the first row (for setting filter options), click anywhere in the table, then click "Data" and deselect "Filter" on the ribbon.

If you add a value in the row just beneath the table, the table and background color formatting will expand to include the additional row.

Upvotes: 0

chris neilsen
chris neilsen

Reputation: 53126

Apply Conditional Formatting, with two rules, each with a different background colour

=ISEVEN(ROW())

and

=ISODD(ROW())

Upvotes: 3

Related Questions