MAX VALUE AND CELL COLOR

Copper Contributor

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 range A2:A3 and the value should  be displayed with cell color in A5. Every time I change the max  in another cell, for example A1 = 60 the max in A5 should be changed with the cell color for A1. 

 

I tried to use =max(range) but it only displays the max value without cell color. 

 

Please Help

 

1 Reply

@justinmakasa 

You may to add = max(range) to A5 and 3 conditional formatting rules (one per each color) like if =A5=A1 then green, etc.