Ranking with Excel
Q: I'm working with election results. We had 27 people contending for nine council positions; choose nine. I'm using the RANK function in Excel to tell me how each candidate ranked within each ward/precinct. Is there a way to write an expression that would boldface any rank/number 9 or below?
A: Simply highlight the entire column and select FORMAT > CONDITIONAL FORMATTING Select CELL VALUE IS and LESS THAN OR EQUAL TO and type in the number 9 now select FORMAT and BOLD and RED and voila everything that is less than or equal to 9 should be red and bold.