checking for cell value when exiting

[shikamikamoomoo]

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!

[Dave Peterson]

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

[shikamikamoomoo]

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!

[Dave Peterson]

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

[shikamikamoomoo]

For one of my documents I need:

If D14>0 then D28 cannot be blank AND
If F14>0 then F14 cannot be blank

Thanks so much for your help....