Hi - I'm on 365 on a Mac, all updated.
I've checked several posts/threads about how to highlight the highest and second highest values in a column. Nothing works quite right for me using the following conditional format formulas:
b20=max($b20:$b1001)
b20=large($b20:$b1001,2)
The maximum value in the column is 40. I get proper formatting on all the 40's listed in the column, except in addition, the last 3 populated cells are formatted the same as 40 (rows 391-393) are also highlighted with the same conditional format, but those three cells don't contain the number 40 (they are all different single digit numbers).
The second highest value is 29. Only the last occurance of the number 29 is highlighted.
Thank you for your help
I've checked several posts/threads about how to highlight the highest and second highest values in a column. Nothing works quite right for me using the following conditional format formulas:
b20=max($b20:$b1001)
b20=large($b20:$b1001,2)
The maximum value in the column is 40. I get proper formatting on all the 40's listed in the column, except in addition, the last 3 populated cells are formatted the same as 40 (rows 391-393) are also highlighted with the same conditional format, but those three cells don't contain the number 40 (they are all different single digit numbers).
The second highest value is 29. Only the last occurance of the number 29 is highlighted.
Thank you for your help