Forum Discussion
MAX VALUE AND CELL COLOR
Hi, I have three cells with data in a worksheet: A1=value 10 cell color Green, A2=value 15 cell color Blue and A3 =45 cell color Yellow. What formulae can I use to pick the maximum value in the ra...
You may to add = max(range) to A5 and 3 conditional formatting rules (one per each color) like if =A5=A1 then green, etc.