I'm using Column A of a spreadsheet to number some items in Column B. Is there a way to automatically number down in Column A, while skipping over the blanks and continuing where I left off, and using different font colors for different numbering, i.e. [LIST=1] 1 2Q H1 EE10 2 2N H1 CC11-2 3 2Q H1 CC11-2 [COLOR=#ff0000]1 2E H1 CC11 2 2N H1 CC11[/COLOR] 4 2Q H1 CC11 5 4E H1 CC11 6 4N H1 CC11 [COLOR=#00ff00]1 4N H1 AA13[/COLOR] 7 2N H1 A13-1 [COLOR=#00ff00]2 2N H1 A13-2[/COLOR] 8 2E H1 B12-UPS [/LIST]