G
Guest
Guest
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. Manually coloring the required amount of cells is not an option since I need to do some 1500 rows every time. I am at a loss. Any suggestions??
Pete
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. Manually coloring the required amount of cells is not an option since I need to do some 1500 rows every time. I am at a loss. Any suggestions??
Pete