Data Validation

[Brian from Maui]

Aloha All,

Data validation in B1 is determinded by what is entered in A1

A1 - 580, 581, 582
then B2 equals to or less than 234

A1 - 583, 584
then B2 equals to or less than 244

Mahalo in advance

[Aladin Akyurek]

On 2002-04-22 12:29, Brian from Maui wrote:
Aloha All,

Data validation in B1 is determinded by what is entered in A1

A1 - 580, 581, 582
then B2 equals to or less than 234

A1 - 583, 584
then B2 equals to or less than 244

Mahalo in advance

Brian,

Set up custom data validation with as formula:

=OR(AND(A1>=580,A1<=582,B2<=234),AND(A1>=583,A1<=584,B2<=244))

Note that 0 and < 0 values are also accepted!

Aladin

[Brian from Maui]

Aloha Aladin,

Mahalo, works like a charm....can't seem to stay away.....even on my day off

Brian