LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 328
Default Data Validation 2003

Hi
I have created a list in column E which contains 3 values. If the use
selects a value from this list, but the cell on column C is blank (also a
list), I want to issue a warning to the user to tell them to put a value
column C (which is also a list) before they can pick from the list in column
E. I presume I must use data validation for this, and have been
experimenting, but I'm not sure how to combine the original list and an 'if'
formula within the same rule

Would appreciate any help
Thanks
 
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
Data Validation Excel 2003 Mike Excel Worksheet Functions 4 May 8th 07 05:06 PM
Data validation with validation lists and combo boxs Keith Excel Discussion (Misc queries) 1 October 12th 06 11:08 AM
Tricky problem in Data validation - Excel 2003 smadhuranath Excel Discussion (Misc queries) 1 July 18th 06 09:10 AM
Excel 2003 - Data Validation Hessen_Wraith Excel Discussion (Misc queries) 8 July 13th 06 08:43 AM
Conditional Data Validation possible in Excel 2003? Norine Excel Discussion (Misc queries) 2 March 14th 06 10:31 AM


All times are GMT +1. The time now is 08:28 PM.

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

About Us

"It's about Microsoft Excel"