basic problem:
I need to indicate progress in 6 steps. I came up with the following:

A row contains 30 cells (each represents a particular phase of a development). I have 6 input fields to indicate the progrees at 6 point in time) . Upon first input (say 2) the first 2 cells of the row should turn red (the other 28 stay white. Upon the second input( say 6), the first 2 cells in the row should stay red, the next four should turn blue (or any other color) etc., etc. After 6 inputs all cells (or part of the total range) have a color.

I got as far as 3 colors becouse Excel does not allow for more than 3 conditional formats. I am at a loss. Any suggestions??