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 ...
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