MAX VALUE AND CELL COLOR

%3CLINGO-SUB%20id%3D%22lingo-sub-2032340%22%20slang%3D%22en-US%22%3EMAX%20VALUE%20AND%20CELL%20COLOR%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2032340%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20three%20cells%20with%20data%20in%20a%20worksheet%3A%20A1%3Dvalue%2010%20cell%20color%20Green%2C%20A2%3Dvalue%2015%20cell%20color%20Blue%20and%20A3%20%3D45%20cell%20color%20Yellow.%26nbsp%3B%20What%20formulae%20can%20I%20use%20to%20pick%20the%20maximum%20value%20in%20the%20range%20A2%3AA3%20and%20the%20value%20should%26nbsp%3B%20be%20displayed%20with%20cell%20color%20in%20A5.%20Every%20time%20I%20change%20the%20max%26nbsp%3B%20in%20another%20cell%2C%20for%20example%20A1%20%3D%2060%20the%20max%20in%20A5%20should%20be%20changed%20with%20the%20cell%20color%20for%20A1.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20tried%20to%20use%20%3Dmax(range)%20but%20it%20only%20displays%20the%20max%20value%20without%20cell%20color.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPlease%20Help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2032340%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

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.