How to require input in a given cell if input in adjacent cell is outside specified range

I am pretty new to Macros and need to find out how to require an input in a given cell if the input in the adjacent cell is outside specified range.

Specifically if the value entered in B16 is less than 150 or greater than 180 I want to require an entry to be made in C16 before allowing the user to go on and do anything else.

Any help would be GREATLY appreciated!!

Maybe:

Please Login or Register  to view this content.

Now this is progress!

Now is there a way that I can allow for any value to be saved in B16, but if it is outside the 150-180 range users have to enter a value in C16. It’s not that I don't want a number outside of the range to be saved, I just want the user to be forced to provide an "explanation" in C16 if it is outside the range.

Try:

Please Login or Register  to view this content.