numbering rows by font color, but skipping blanks

Excel Discussion in 'Microsoft Office' started by JoeyOreally, Jan 10, 2018.

  1. JoeyOreally


    Jan 10, 2018
    Likes Received:
    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.

    1. 1 2Q H1 EE10
      2 2N H1 CC11-2
      3 2Q H1 CC11-2

      1 2E H1 CC11
      2 2N H1 CC11

      4 2Q H1 CC11

      5 4E H1 CC11
      6 4N H1 CC11
      1 4N H1 AA13
      7 2N H1 A13-1

      2 2N H1 A13-2
      8 2E H1 B12-UPS
    JoeyOreally, Jan 10, 2018
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.