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

 

[tagan]

conditional formatting did not work possibly because there are validation formulas in each cell that return "OK" or "Error" depending on input in a different cell - is this correct? - if so any other suggestions?

 

[BenMiller]

On D57 do two separate conditional formattings, with formulas. One for =D57="Error" and one for =D57="OK" .

 

[tagan]

It is saying "no relative references" with formula

 

[BenMiller]

So try $D$57 instead of D57 ..

 

[tagan]

Thanks - it still did not work - trying to be a perfectionist - need to go some other things now --- thanks again

 

[BenMiller]

You don't really have to do a formula .. you could try Cell Value is Equal To (from the drop-down menu in the CF dialog box) and type ok