Hi!

You can use a similar event procedure on OTHER sheets but you can't have
more than 1 per sheet.

OTOH, you can use similar conditional formatting techniques to your hearts
content!

Biff

"Bullman" wrote in message
oups.com...
Awesome solutions guys! :D

Biff, I think your solution is probably the best that can be done
without any VBA assistance. I was toying with a similar concept but
your use of a Conditional Format to make the cell appear to be blank
(and hence act as a kind of flag/prompt for the user to then go and
fill it in with data) is a very clever work around I hadn't considered.

Ardus, your use of VBA certainly provides a 100% solution to the
problem. I have had a look at the code for that script that
automatically resets cell B1 to <select vale if changes to A1 make the
current value in B1 invalid. Unfortunately my lack of VBA code
knowledge prevents me from fully understanding the code used. I wish
to at least obtain a better undertanding of the VBA code used in the
script so I can modify and adapt the one you wrote and apply it to
other cells (with different conditions) on the same worksheet and on
other worksheets.

Can you perhaps suggest a good starting point?

Sincerest thanks!

Bullman