Sep 09 2021 10:50 PM
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
Sep 10 2021 01:25 AM
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$900
or which ranges you use
Sep 10 2021 01:28 AM
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.
Sep 12 2021 04:49 PM
Sep 12 2021 04:49 PM