Consulting

Results 1 to 3 of 3

Thread: How far is the first occurrence of a coloured cell

  1. #1
    VBAX Regular
    Joined
    Jan 2015
    Posts
    92
    Location

    How far is the first occurrence of a coloured cell

    Hi to everyone
    I would like for each row in column A, to be returned the number of cells present starting from column C that do not have set the background color until the first occurrence of a cell with a green background color, see the attached sample.

    thanks for any help
    Attached Files Attached Files

  2. #2
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,844
    See formula in column AJ.
    Attached Files Attached Files
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.

  3. #3
    VBAX Regular
    Joined
    Jan 2015
    Posts
    92
    Location
    Good morning p45cal


    that's exactly what I meant


    sincere thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •