Forum Discussion
Ioannisd
Jan 12, 2023Copper Contributor
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
HansVogelaar
Jan 12, 2023MVP
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.
Ioannisd
Jan 13, 2023Copper Contributor
Thank you,
but it doesn't work. i forget to mention that i work in Excel 2010🤨
Do we have any other solution?