If you'd like to email me your sample workbook, I could take a look at it.
Remove the XSPAM from my email address:

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html


"NealMed" wrote:

Starting with a new worksheet document. Using the cells and Formula exactly
as you decribe, is what i did. I wanted to just see it in action before
placing it into my worksheet. This is what happens. If i click on the drop
down and choose either 1 or 2, then 1 or 2 of the cells turn white and are
usable, (i chose red as my block off color). when i choose 3 - 9 from the
drop down menu, it will not clearthe 3rd - 9th cells to white. If i select
say 4 from the drop down menu, then 2 will clear, leaving everything else
still red. Where the 3rd and 4th cells are that should have turned white, if
i double click them they will turn to white and let me place text there, and
the 5th, 6th, 7th, etc cells will not clear to white with the double click.
They remain blocked off as they should. That is the problem that i'm having
with this one. Thanks for being so stead fast in helping me. :)
--
NealMed


"Debra Dalgleish" wrote:

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