ExcelBanter - How can I alternate row colors in Excel and keep the effect?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How can I alternate row colors in Excel and keep the effect? (https://www.excelbanter.com/excel-discussion-misc-queries/70103-how-can-i-alternate-row-colors-excel-keep-effect.html)

D-Lydon

How can I alternate row colors in Excel and keep the effect?

How can I alternate row colors in Excel and keep the effect after changing
the sort order???

wAyne

How can I alternate row colors in Excel and keep the effect?

I don't know if there is an easier way ... but...
you could use conditional formating and the following formula.

=MOD(ROW(),2) 0
this will set odd rows to whatever formating you want ...

"D-Lydon" wrote:

How can I alternate row colors in Excel and keep the effect after changing
the sort order???

bigwheel

How can I alternate row colors in Excel and keep the effect?

Have a look at http://www.cpearson.com/excel/banding.htm

"D-Lydon" wrote:

How can I alternate row colors in Excel and keep the effect after changing
the sort order???

All times are GMT +1. The time now is 08:37 PM.