RE: $$Excel-Macros$$ Validation rule and 'X'

2010-08-27 Thread Dave Bonallack
Hi, Yes, it's possible to have more than one rule. Let me know what it is you actually need, and I'll try to help you acheive it. Regards - Dave. > Date: Fri, 27 Aug 2010 07:53:14 -0700 > Subject: Re: $$Excel-Macros$$ Validation rule and 'X' > From: janes...

Re: $$Excel-Macros$$ Validation rule and 'X'

2010-08-27 Thread Amazon
Hi Dave, The first solution was exactly what I needed. Works great. Now, is is possible to have more than one validation rule per cell, perhaps by creating an array in the Formula box under Validation / Settings? Hane -- --

RE: $$Excel-Macros$$ Validation rule and 'X'

2010-08-27 Thread Dave Bonallack
Hi, First of all, you can't use Data Validation after the data is entered. You may apply the validation, but it won't react to invalid data. It only responds to data entered after the validation rule is in place. If you want to be alerted to invalid data that is already present, you'd probably