I'm pretty sure I have seen a post about this before, but....I can'
find it. I would like to have excel check for a value 0 IF cel
above is 0. I would like it to verify that this cell has info entere
in if it meets criteria before the doc can be saved and/or printed.


If A2=55 then R2 should have a value 0 entered into it.
If A2=0 then R2 can be blank

Any help or reference link/material would be appreciated.

Thanks! :

--
shikamikamoomo
-----------------------------------------------------------------------
shikamikamoomoo's Profile: http://www.excelforum.com/member.php...fo&userid=2101
View this thread: http://www.excelforum.com/showthread.php?threadid=46963