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