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

D

D-Lydon

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

wAyne

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

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

Printing from Word my Inserted Pictures colors are dull and lack color 0
I screwed up 0
alternate row formatting in 2007-problems 0
No row numbering and column lettering 1
alternate row shading kept with autofilter 3
alternate row shading on filtered data 2
My Visio2019 Keep Crashed when open the program 0
Dealing with a Pivot Table (when I don't want to) 0

Top