How can I alternate row colors in Excel and keep the effect after changing the sort order???
D D-Lydon Feb 7, 2006 #1 How can I alternate row colors in Excel and keep the effect after changing the sort order???
W wAyne Feb 7, 2006 #2 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 ...
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 ...
