Forum Discussion
Conditional Format - Compare 3 different cells for highest value
Hi I have sheet with 3 values i want only the highest to highlight I can work out how to compare 2 cells and return the highest with a yellow shade. What I can't work out is how to compare ...
1. Select O2, AE2 and AM2.
Use the Tab key to make O2 the active cell in the selection.
On the home tab of the ribbon, select Conditional Formattting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=O2=MAX($O2,$AE2,$AM2)
Click Format...
Activate the Fill tab.
Select yellow.
Click OK, then click OK again.
- Thank you
