On 2002-03-01 11:50, all4sport wrote:
Is there any way to have excel automatically highlight the highest or lowest number in a column. I don't wish for it to sort or move anything around. I just have weekly data and I want to automatically see the highs and lows.
On 2002-03-01 15:25, all4sport wrote:
So will that let me choose one high cell out of those 3 groups?
On 2002-03-01 15:25, all4sport wrote:
So will that let me choose one high cell out of those 3 groups?
On 2002-03-01 19:57, all4sport wrote:
This is my goal.
This is an example of the data.
A1
A2
A3
A7
A8
A9
A14
A15
A16
What I want is to highlight the highest value out these 9 cells. What I'm having trouble with is the fact that they aren't all in succession of each other. Thanks in advance for you patience and help. If I can have it highlight the lowest at the same time is an added bonus.