| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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??? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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??? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
