Conditional Format - Compare 3 different cells for highest value

Copper Contributor

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

@debmsge 

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

@debmsge 

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.