Mandatory Input of a Cell
I have an input template in Excel 2002 that other users will update with
information. I want to make sure they input a description beside the number. How can I make the description cell a mandatory input if they input a number? Thanks, Tammy |
Mandatory Input of a Cell
I'd use an adjacent cell that was formatted in big bold red letters:
=if(a1<"","","<-- Please enter something here!" newfie51971 wrote: I have an input template in Excel 2002 that other users will update with information. I want to make sure they input a description beside the number. How can I make the description cell a mandatory input if they input a number? Thanks, Tammy -- Dave Peterson |
Mandatory Input of a Cell
Maybe you could create a lookup table and a formula in mandatory cell with a
VLOOKUP formula to return the description based upon the input number? Users would only have to enter the number. Visit Debra Dalgleish's site for info on VLOOKUP function to pull data based on value. Note the downloadable sample workbooks. http://www.contextures.on.ca/xlFunctions02.html Also see Debra's site for info on Data Validation selection lists for inputting the data if need be. http://www.contextures.on.ca/xlDataVal01.html Gord Dibben MS Excel MVP On Tue, 15 Jul 2008 06:47:04 -0700, newfie51971 wrote: I have an input template in Excel 2002 that other users will update with information. I want to make sure they input a description beside the number. How can I make the description cell a mandatory input if they input a number? Thanks, Tammy |
All times are GMT +1. The time now is 09:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com