OK, So it has been like 9 years since I have used excel... I was able to get most of my project for work completed but am now stuck and need some help.
I have collumn with 9 numbers that get re-entered daily... for example
10
15
10
45
80
0
10
5
40
I want to have the seven of these that are both consecutive within the collumn and have the highest SUM to be highlited. I have tried all kinds of conditional formatting but cant get it to work. Thank you in advance.
I have collumn with 9 numbers that get re-entered daily... for example
10
15
10
45
80
0
10
5
40
I want to have the seven of these that are both consecutive within the collumn and have the highest SUM to be highlited. I have tried all kinds of conditional formatting but cant get it to work. Thank you in advance.
