To find Maximum value using conditional formatting

[hyukfgh]

how in ms excell 2010, how to find maximum value in cell E and give maximum cell light green fill color and font as dark green color.HOw to do it.USING CONDITIONAL FORMATTING command on ms excell 2010 menu.
E
234
45
0
-56
78
286
0
55
Regards.

 

[themausman]

Good question! I have a solution you might be able to use. Select the cells you want to apply the conditional formatting on. Go to the Home tab and click Conditional Formatting. From the dialog choose new rule. From the next dialog choose the third option: Format only Top or bottom ranked values. By default this is set to Top 10. Change this value to 1. Choose the formatting you like (green fill with dark green font) and click ok. Choose apply and see how your highest value will be formatted. Change another value to be the highest and see how that cell will be colored accordingly. You can also use this technique for the lowest value. In that case choose Bottom instead of Top and choose different colors.

Hope this helps
Maurice

 

[hyukfgh]

SOLVED.Thanks.