checking for cell value when exiting
 

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

checking for cell value when exiting
 

I'm confused about the cell and the cell above.

I don't see how A2 and R2 fit that situation.



shikamikamoomoo wrote:

I'm pretty sure I have seen a post about this before, but....I can't
find it. I would like to have excel check for a value 0 IF cell
above is 0. I would like it to verify that this cell has info entered
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! :)

--
shikamikamoomoo
------------------------------------------------------------------------
shikamikamoomoo's Profile: http://www.excelforum.com/member.php...o&userid=21018
View this thread: http://www.excelforum.com/showthread...hreadid=469635

--

Dave Peterson

checking for cell value when exiting
 

I meant a cell somewhere above on the sheet....sorry I screwed up the
example...

How about:

If A2=55 then you cannot print and/or exit if A25 is blank.

Thanks for pointing that out Dave!


--
shikamikamoomoo
------------------------------------------------------------------------
shikamikamoomoo's Profile: http://www.excelforum.com/member.php...o&userid=21018
View this thread: http://www.excelforum.com/showthread...hreadid=469635

checking for cell value when exiting
 

Do you have specific cells that apply?

shikamikamoomoo wrote:

I meant a cell somewhere above on the sheet....sorry I screwed up the
example...

How about:

If A2=55 then you cannot print and/or exit if A25 is blank.

Thanks for pointing that out Dave!

--
shikamikamoomoo
------------------------------------------------------------------------
shikamikamoomoo's Profile: http://www.excelforum.com/member.php...o&userid=21018
View this thread: http://www.excelforum.com/showthread...hreadid=469635

--

Dave Peterson

checking for cell value when exiting
 

For one of my documents I need:

If D140 then D28 cannot be blank AND
If F140 then F14 cannot be blank

Thanks so much for your help....

:cool:


--
shikamikamoomoo
------------------------------------------------------------------------
shikamikamoomoo's Profile: http://www.excelforum.com/member.php...o&userid=21018
View this thread: http://www.excelforum.com/showthread...hreadid=469635