Highlight higher value of different cells

New Contributor



i want to highlight  higher value(cell) in every row from different - seperate collums

for example  i have B2 , D2 , F2 cells with values

6 Replies


Let's say the data are in B2:B50, D2:D50 and F2:F50.

Select F2:F50.

Hold down Ctrl and select D2:D50.

Still holding down Ctrl, select B2:B50.

You should now have selected all three ranges, with B2 as active cell.

On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula


Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.

@Hans Vogelaar 

Thank you,

but it doesn't work.   i forget to mention that i work in Excel 2010🤨


Do we have any other solution?


If you follow Mr. Hans Vogelaar's steps it should work without any problem...it works for me.

Attached is an additional example file.

Conditionally Formatting  Data: Examples and Guidelines

...for do-it-yourself


still it's not working.
If I may recommend, include this file (without sensitive data) so that we can understand why it doesn't work for your file.
It works and I think you need check your formular:
Use "=B2=MAX($B2,$D2,$F2)"
Not "=B2=MAX($B$2,$D$2,$F$2)"