Maintaining Row Color

[heroquestelf]

Here is basically what I'm trying to do: I want to create a spreadsheet with the numbers: 2 8 4 10 6, each on a separate row. Then, once sorted, I am going to make each group of two rows a different color. Thus: the rows with numbers 2 & 4 will be white; the rows with 6 & 8 will be grey, & the row with 10 will be white. Now, here is what I don't know how to do: I want to be able to enter the number 5 and re-sort and maintain my 2 row color setup. Thus, now, 2 & 4 will be white, 5 & 6 will be grey, and 8 & 10 will be white. Is there a way to do this?

 

[heroquestelf]

Is that a "it can't be done" or an "I Don't Know"?

Let me try this again. I'm using Office 2003. I want to take a sheet that looks like this:

Hit the "Sort" button, and have the result look like this:

Can this be done?