Validation across multiple cells

[tagan]

I been successful with the following =IF(OR(D43=0,D43="Y"),"OK","Error") in D 57 for cell D43 but want to extend it to validate D43:D45 with "OK" or "Error" displaying only in D57 for the three cells validated and I cannot figure out how .. I am so frustrated I am actually asking for help

 

[BenMiller]

So explain exactly when you want it to display "Ok" and when you want it to display "Error" ... what if D43 is "Y", D44 is 0, and D45 is some other value?

 

[tagan]

If any of the three cells do not have "Y" or "0" then I want to display "error" in D57

 

[tagan]

And given that today is your 21st birthday please have a beer on me

 

[BenMiller]

Thanks! And try
=IF(AND(OR(D43=0,D43="y"),(OR(D44=0,D44="y")),(OR(D45=0,D45="y"))),"OK","Error")

Note: Keep in mind that a cell with nothing entered in it evaluates to a zero.

 

[tagan]

Works awesome - I tried a zillion ways last night but this was beyond my VERY rusty excel skills

 

[BenMiller]

No problem Glad I could help Appreciate the feedback!

 

[tagan]

The beer smile is too funny ... one other question ... is there any way for "error" to display in color red, "OK" in green?

 

[BobUmlas]

Use conditional formatting.

 

[tagan]

got it - thanks