Data validation based on several fields

[yobi4ever]

Hi,
I've tried several options with no luck and I would truly appreciate any help.
I have something similar to this:

A B C
1 3 Y
2 5 N
3


If the user enters 15:30 or less in C1, C2,C3...etc then accept it unless
(A1 is equal to (6 or 7)) and (B1 equal to Y)
A2 is equal to 6 or 7 and B2 equal to Y
...ETC

[NBVC]

Try this formula in the Formula field of the Data Validition Custom option:

=AND(C1<="15:30"+0,NOT(AND(OR(A1=6,A1=7),B1="Y")))

you can then copy the data validation to the other cells via Edit|Paste Special >> Validation

[yobi4ever]

Thank you very much!! This is perfect.
I will try to understand the logic.

God bless Canada
I'm Canadian after all

[yobi4ever]

Your solution works perfect

[yobi4ever]

Hi,
What is the +0 next to "15:30"?

Thank you.

[NBVC]

It converts the text value "15:30" into the numeric value (ie. 0.645833333333333 , which is the serial number Excel uses for 15:30) so that the comparisons can be done.