Conditional formatting by specific rule through many rows.

[GummifF]

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.

[p45cal]

Only 2 CFs needed:

2024-06-23_204111.jpg

Note how both 31s have been highlighted in row 6

2024-06-23_204536.jpg

[Aussiebear]

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?

[GummifF]

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..

[GummifF]

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.

[Aussiebear]

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.