Consulting

Results 1 to 6 of 6

Thread: Conditional formatting by specific rule through many rows.

  1. #1
    VBAX Newbie
    Joined
    Jun 2024
    Posts
    3
    Location

    Conditional formatting by specific rule through many rows.

    Hi there.

    Can anyone help me with this, my brain is overcooking.
    According to the image, I want Excel (either using VBA macro, or conditional formatting) to color the font RED of the lowest value between columns D,G,J,M in every row (ignoring other columns).
    I can do this very easily with Conditional formatting but there are 60 rows and then I need to do the same for columns E,H,K,N so it will end up being 120 conditional formatting rules just for this particular sheet.

    It should look like the picture.

    Image.jpg

    Any help would be appreciated.

  2. #2
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,910
    Only 2 CFs needed:

    2024-06-23_204111.jpg

    Note how both 31s have been highlighted in row 6

    2024-06-23_204536.jpg
    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
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,183
    Location
    Welcome to VBAX GummifF. To be honest I'm surprised that P45cal was able to come up with a solution based upon the data supplied in your attached image. A sample workbook would have so much better to work with.

    Whilst P45cals's example works beautifully with his data, I notice that your example Player 4 is potentially missing data. Was that a typo?
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

  4. #4
    VBAX Newbie
    Joined
    Jun 2024
    Posts
    3
    Location

    Thumbs up

    Quote Originally Posted by p45cal View Post
    Only 2 CFs needed:

    2024-06-23_204111.jpg

    Note how both 31s have been highlighted in row 6

    2024-06-23_204536.jpg
    Thanks a million CF, your a life saver... Somehow I managed to put the formula in the wrong place but I still would not have figured it out..

  5. #5
    VBAX Newbie
    Joined
    Jun 2024
    Posts
    3
    Location
    That was my bad, did not think of including it, the workbook is quite big.
    The missing data is intentional, this is based on 4 players in a team and I wanted to see what would happen if only 3 players which can happen.

  6. #6
    Moderator VBAX Wizard Aussiebear's Avatar
    Joined
    Dec 2005
    Location
    Queensland
    Posts
    5,183
    Location
    Fair enough, but you should have explained that in the initial post. its one thing to explain what you want, but if the initial data contains extra tests (factors) that we don't know about, then its all too easy to head off in the wrong direction. Luckily P45cal was smart enough to decipher the main intent. I'm glad you got it solved.
    Remember To Do the Following....
    Use [Code].... [/Code] tags when posting code to the thread.
    Mark your thread as Solved if satisfied by using the Thread Tools options.
    If posting the same issue to another forum please show the link

Tags for this Thread

Posting Permissions

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