Forum Discussion
Highlight higher value of different cells
hi,
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
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 🙂
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=B2=MAX($B2,$D2,$F2)
Click Format...
Activate the Fill tab.
Select a highlight color.
Click OK, then click OK again.Thank you,
but it doesn't work. i forget to mention that i work in Excel 2010🤨
Do we have any other solution?
