Does anyone know how to set more than 3 conditional formats? I want the user
to be able to type in a number and date in a cell like so:

1 04/05/07

and based on the number in the left most position, shade the cell a specific
color. I would have up to 7 different color shades.

Thanks,

Sarah