Conditional Formatting to get top counts in ranges

Hi All,

Relative Excel 2007 novice here. I am trying to set up a spreadsheet which allows people to sort and highlight groups of numbers based on their preferences.

I first set up a macro to sort the data columns into the appropriate format (by % of sales).

I want the user to be able to input 5 numbers (which would be the # size of 5 groups), and excel to highlight and divide one column based on that input. I'm thinking (in pseudo-code) along the lines of:

x1 = 5, x2 = 10. If(Row >/= x1 and </= x2, Highlight Cells Red). And so forth.

Is there a way to do this using conditional formatting, or something? Attached is a basic rubrik that I am working with.