What is the formula to apply color to the maximum value? thank you in advance for your assistance.
T tony wong May 6, 2004 #1 What is the formula to apply color to the maximum value? thank you in advance for your assistance.
A Andy B May 6, 2004 #2 Hi If your range is A1:A10, select the range (starting at A1), and use 'Formula is' with =A1=MAX($A$1:$A$10)
Hi If your range is A1:A10, select the range (starting at A1), and use 'Formula is' with =A1=MAX($A$1:$A$10)
