N Norfolk Bill Mar 9, 2009 #1 I have asked for the max value to be shown in a colum. How can I ask for the cell to be auto highlighted.
I have asked for the max value to be shown in a colum. How can I ask for the cell to be auto highlighted.
G Gord Dibben Mar 10, 2009 #2 Column A example. Select column A then Conditional Formatting>Formaula is: =A1=MAX(A:A) Format to a color you like. Gord Dibben MS Excel MVP On Mon, 9 Mar 2009 16:34:01 -0700, Norfolk Bill <Norfolk
Column A example. Select column A then Conditional Formatting>Formaula is: =A1=MAX(A:A) Format to a color you like. Gord Dibben MS Excel MVP On Mon, 9 Mar 2009 16:34:01 -0700, Norfolk Bill <Norfolk
S Shane Devenshire Mar 10, 2009 #3 Hi, In 2007 highlight the range and choose Home, Conditional Formatting, Top/Bottom Rules, Top 10 Item, and change 10 to 1...
Hi, In 2007 highlight the range and choose Home, Conditional Formatting, Top/Bottom Rules, Top 10 Item, and change 10 to 1...
