Conditional formatting using multiple AND OR formula

[edmcgregor]

Hi,

I'm working on a spreadsheet which will identify whether a chosen catergory (either "Gateway",Visitor welcome", "Commercial", and "Community") in column F matches with critera in following columns - all "yes" or "no" answers. Basically I want it to flag up if there is a "no" answer in any of cells in the the same row where the answer should be "yes" for the chosen F3 catergory, by highlighting the whole row. I'm using the OR function as the parent with nested AND functions, so if any of the AND functions return TRUE, the OR Function should return a "TRUE" answer overall.

This is the formula I have arrived at, and I believe should logically work, but it doesn't.

=OR(AND(F3=”Gateway”,H3=”Yes”,J3=”Daily”,K3=”Yes”,L3=”Yes”,P3=”Yes”,Q3=”Yes”,S3=Yes”,U3=”Yes”,V3=”Yes”,X3=”Yes”(F3=”Visitor Welcome”,S3=”Yes”,U3=”Yes”,V3=”Yes”,X3=”Yes”(F3=”Commercial”,N3=”Yes”,O3=”Yes”(F3=”Community”,T3=”Yes)))))

Is there something obviously wrong with this formula / or applying to conditional formatting.
I've attached the spreadsheet - all info on sheet one. If anyone could help with this it would be much appreciated.

Thanks