Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rob
 
Posts: n/a
Default Blocking entry of data in a cell

I have created a time sheet with four time periods, there are two possible
entries in each period "Travel Time" and "Labor". I want to restrict entry to
one or the other of these cells per period. I would also like to display a
message if an attempt is made to enter data into both cells of the same
period. I have been unable to find a solution in the help files.
Thanks
Rob
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Debra Dalgleish
 
Posts: n/a
Default Blocking entry of data in a cell

You can use data validation to prevent typing in both cells. For
example, if the cells are C2 and D2:

Select cell C2, and choose Data Validation
From the first dropdown, choose Custom
In the Formula box, type: =D2=""
Select the Error Alert tab, and type your message.
Click OK

Do the same in cell D2, with the formula: =C2=""

Note that users would be able to paste values into both cells -- data
validation only prevents invalid entries that are typed.

Rob wrote:
I have created a time sheet with four time periods, there are two possible
entries in each period "Travel Time" and "Labor". I want to restrict entry to
one or the other of these cells per period. I would also like to display a
message if an attempt is made to enter data into both cells of the same
period. I have been unable to find a solution in the help files.
Thanks
Rob



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Macro to Copy & Paste [email protected] Excel Worksheet Functions 0 December 1st 05 02:56 PM
How can I populate an Excel cell based on the data in another cell JerseyBoy Excel Worksheet Functions 3 September 30th 05 03:53 PM
Vlookup for data contained in a cell Garbunkel Excel Worksheet Functions 5 September 14th 05 06:47 PM
Sort pages? David Excel Discussion (Misc queries) 15 May 13th 05 11:33 PM
Splitting Data in a Cell Newbie1092 Excel Worksheet Functions 3 May 10th 05 05:48 PM


All times are GMT +1. The time now is 11:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"