I'm not sure which cells you're double-clicking on, or what's in those
cells when you double-click on them. Can you describe what you're doing?

Is the worksheet clear when you start, excepting for the formatting, or
are there values in any of the cells?

NealMed wrote:
To make sure that i had the correct idea, i started with a new worksheet, and
used the exact cells and formula that you prescribed in the first answer. It
did block them the color i wanted, i changed the number from 1 to 2 and it
worked, then when i went to 3, it didn't change. If i double clicked on the
cell for the 3rd one, it would clear and i could use it, but i could not use
the 4th, so i set it to the 4th, and it didn't change, but i could double
click the 4th cell and the same occured, and i could use it, and so on.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html