Conditionally Formatting (Highlighting) Top 5 / Bottom 5 when there are two scales in same column?

[kalamazoo]

I have a column of topic scores. Around 50 cells. I am trying to highlight the bottom 5 and top 5. There are about 10 of these topics that are on a reverse scale meaning a lower score would actually be better and could put them in the top and a higher score would be worse and could put them in the bottom.

How would I go about addressing this? Is there a way to factor in the reverse scale for the highlighting?

The scale is from 1 - 5. On most topics 5 is the best score but on the reverse 1 is the best.

Thanks!

 

[kalamazoo]

What I ended up doing was just using the =ABS on the reverse scale items and that seems to make sense. Well I hope it does anyway