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 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
You may to add = max(range) to A5 and 3 conditional formatting rules (one per each color) like if =A5=A1 then green, etc.
