will column C always stay the same Moee?,
You could use conditional formatting to highlight with say red traffic lights or Flags for 6-8 and 5th could be a yellow traffic light and green for the rest of the field, based on the ranking in column C