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.
--
NealMed


"Debra Dalgleish" wrote:

What range of cells did you format? What formula did you use for
conditional formatting, and what formula for Data Validation?

NealMed wrote:
Thanks it partly worked, the problem i'm having now, is that it won't
acctually follow the numbes, if i say select 7, it will only clear the red
color from the top two cells, but not the others, if you click on them to
type you can, but you have to click on them to get them to remove the shaded
color.


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