| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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....  -- shikamikamoomoo ------------------------------------------------------------------------ shikamikamoomoo's Profile: http://www.excelforum.com/member.php...o&userid=21018 View this thread: http://www.excelforum.com/showthread...hreadid=469635 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Force a comment before exiting a cell | Excel Worksheet Functions | |||
| Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
| Move cursor to...on exiting cell | Excel Discussion (Misc queries) | |||
| Calculate Sum in one cell after Exiting (ENTER or TAB) another cel | Excel Discussion (Misc queries) | |||
| reight click a cell without exiting from input mode | Setting up and Configuration of Excel | |||
![shikamikamoomoo[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
