I have a column of 50 cells with various numbers and I, through the Top/Bottom Conditional Formating Rule, highlight the 10 highest numbers and the 10 lowest numbers.
How can I highlight the highs and lows while ignoring both "0" or blank cells?
Regards,
Gary
Bookmarks