Validation rule but only sometimes

On Tue, 21 Jun 2005 20:22:43 -0500, aaron.kempf@gmail.com <aaron.kempf@gmail.com> wrote:

> Microsoft Access has _MUCH_ better validation for this type of thing
>
> Good luck
>
> -Aaron


Yeah, I figured that.

This was supposed to be a pretty simple spreadsheet,
and I just wanted to make a few cells have different
content depending on what other cells had in them.

It's not worth the time to switch to Access, and the
very few people who might ever see this won't want to
bother with Access. (It might not even be worth my
time doing it the way I'm heading, anyway. <grin>)

Mike

On Tue, 21 Jun 2005 20:26:31 -0500, Broida (spamless) <Broida@charter.not.net> wrote:

> On Tue, 21 Jun 2005 20:22:43 -0500, aaron.kempf@gmail.com <aaron.kempf@gmail.com> wrote:
>
>> Microsoft Access has _MUCH_ better validation for this type of thing
>>
>> Good luck
>>
>> -Aaron
>
>
> Yeah, I figured that.
>
> This was supposed to be a pretty simple spreadsheet,
> and I just wanted to make a few cells have different
> content depending on what other cells had in them.
>
> It's not worth the time to switch to Access, and the
> very few people who might ever see this won't want to
> bother with Access. (It might not even be worth my
> time doing it the way I'm heading, anyway. <grin>)

And I figured I might learn something useful
by asking here how to do it.

Mike