Boards
Excel question
I can conditionally format, say, the 5 highest values in a list, but my list has both positive and negative values, and I want to highlight the 5 which are furthest from zero, positive or negative. CAN THIS BE DONE?
I can conditionally format, say, the 5 highest values in a list, but my list has both positive and negative values, and I want to highlight the 5 which are furthest from zero, positive or negative. CAN THIS BE DONE?