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 3 cells to return a highest cell yellow only.
Example - Cell O2 is 49.58 cell AE2 is 49.74 cell AM2 is 33.56 - so only cell O2 should shade yellow.
Also separate condition in the row 2 column B to N I want to apply the conditonal format in every row - which i can do - but to not apply until at least once cell has a value in it.
thank you Deb
4 Replies
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
Conditional formatting rule formula could be
=(O2=MAX($O2,$AE2,$AM2) )*( ( ($O2<>"")+($AE2<>"")+($AM2<>"") ) > 0)applied to
=$O$2:$O$900,$AE$2:$AE$900,$AM$2:$AM$900or which ranges you use
- Thank you
