close
How can I alternate row colors in Excel and keep the effect after changing
the sort order???
I don't know if there is an easier way ... but...
you could use conditional formating and the following formula.
=MOD(ROW(),2) gt; 0
this will set odd rows to whatever formating you want ...
quot;D-Lydonquot; wrote:
gt; How can I alternate row colors in Excel and keep the effect after changing
gt; the sort order???
Have a look at www.cpearson.com/excel/banding.htm
quot;D-Lydonquot; wrote:
gt; How can I alternate row colors in Excel and keep the effect after changing
gt; the sort order???
全站熱搜
留言列表
