Color alternate excel rows based on duplicate numbering system.
Posted on 2013-01-29
I have a Excel 2003 spreadsheet. In Column A I have the numbering system below which will go beyond 150 by the end of the year. I would like to use something like conditional formatting so each new number sequence is an alternate color (grey/white) across to Column AO. (Color in bracket for emphasis only)
etc, etc, etc
As soon as the number is entered, it colors that row to the alternate color to Column AO
Thank you in advance.