Conditional Formatting - largest of 3 cells

[amandakayelitte]

I need to write a conditional format to highlight the largest % of three columns. If the largest is in column J (positive) it will need to be green, if column I (neutral) it will need to be yellow, if column H (negative) it will need to be red. If there is a tie in two columns both will need to be yellow. Any help would be appreciated!


Column H Column I Column J
Negative % Neutral % Positive %
Row 1 0.0% 0.0% 100.0%
Row 2 50.0% 50.0% 0.0%
Row 3 0.0% 75.0% 25.0%

[6StringJazzer]

For future reference, it's better if you just attach your Excel file.

I have mocked one up using what you describe. You need four conditional formatting rules:

One for each column, because you want three different colors. The formulas are the same; they check to see if the cell is the maximum value in the row, and also is not duplicated.
The fourth rule applies to all three columns. It checks to see if the cell is the maximum value and also duplicated.