Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enforce cell completion
I have a worksheet with which I want to make sure particular cells have
content filled in them before it is closed. Could anyone give me some instruction on how to do this. Im new to this so any detail on where to go and what to put in would be more than appreciated. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enforce cell completion
Apart from using a big stick there is no foolproof way to do this, as whilst you could write VB code to request cell completion you cannot force a user to enable macros when opening a workbook. Closest is a reminder, via select the required cell, and Format, Conditional Formatting, and set Cell Value, is Equal to, ="" and set the Pattern to Red. This will highlight all required cells that have not yet been given a value. HTH --- Simon Wrote: I have a worksheet with which I want to make sure particular cells have content filled in them before it is closed. Could anyone give me some instruction on how to do this. Im new to this so any detail on where to go and what to put in would be more than appreciated. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=559263 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enforce cell completion
That works great thanks.
Moving on from that what would the formula be if cell A2 was to show red if it had no contents but only if cell A1 had been filled in? Thanks for the advice €“ lots made my day a lot more productive! "Bryan Hessey" wrote: Apart from using a big stick there is no foolproof way to do this, as whilst you could write VB code to request cell completion you cannot force a user to enable macros when opening a workbook. Closest is a reminder, via select the required cell, and Format, Conditional Formatting, and set Cell Value, is Equal to, ="" and set the Pattern to Red. This will highlight all required cells that have not yet been given a value. HTH --- Simon Wrote: I have a worksheet with which I want to make sure particular cells have content filled in them before it is closed. Could anyone give me some instruction on how to do this. Im new to this so any detail on where to go and what to put in would be more than appreciated. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=559263 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enforce cell completion
Simon
You seem satisfied with the answer you received, but how will that "enforce cell completion" before closing? I, as user, can simply ignore your red flags and carry on. Gord Dibben MS Excel MVP On Fri, 7 Jul 2006 09:08:01 -0700, Simon wrote: That works great thanks. Moving on from that what would the formula be if cell A2 was to show red if it had no contents but only if cell A1 had been filled in? Thanks for the advice – lots made my day a lot more productive! "Bryan Hessey" wrote: Apart from using a big stick there is no foolproof way to do this, as whilst you could write VB code to request cell completion you cannot force a user to enable macros when opening a workbook. Closest is a reminder, via select the required cell, and Format, Conditional Formatting, and set Cell Value, is Equal to, ="" and set the Pattern to Red. This will highlight all required cells that have not yet been given a value. HTH --- Simon Wrote: I have a worksheet with which I want to make sure particular cells have content filled in them before it is closed. Could anyone give me some instruction on how to do this. Im new to this so any detail on where to go and what to put in would be more than appreciated. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=559263 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Enforce cell completion
The formula would then be: set to Formuls (not Cell Value = ) =AND($A$1<"",B1="") As Gord Dibben pointed out this does not 'enforce' completion, merely highlights the requirement. HTH --- Simon Wrote: That works great thanks. Moving on from that what would the formula be if cell A2 was to show red if it had no contents but only if cell A1 had been filled in? Thanks for the advice €“ lots made my day a lot more productive! "Bryan Hessey" wrote: Apart from using a big stick there is no foolproof way to do this, as whilst you could write VB code to request cell completion you cannot force a user to enable macros when opening a workbook. Closest is a reminder, via select the required cell, and Format, Conditional Formatting, and set Cell Value, is Equal to, ="" and set the Pattern to Red. This will highlight all required cells that have not yet been given a value. HTH --- Simon Wrote: I have a worksheet with which I want to make sure particular cells have content filled in them before it is closed. Could anyone give me some instruction on how to do this. Im new to this so any detail on where to go and what to put in would be more than appreciated. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=559263 -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=559263 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
insert date | Excel Worksheet Functions | |||
Compiling macro based on cell values | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
Dates of a Day for a month & year cell formulas | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |