Need help using AND in Conditional Formating

I cannot figure out how to use AND with two variables. The concept is, that a column formatting needs to be changed if NO from the declarations-page is selected. For example for the color Yellow, If I select YES for yellow in the declarations page, all the YELLOW CELLS in Column L should be yellow which is the default color. If I select NO for yellow in the declarations page, than the Yellow color would be disabled.

In the program attached only cell L10 does what I want it to do, when I select YES or NO, only cell L10 changes. I want the whole column to. Any Help would be appreciated.

Try:

=SUMPRODUCT(COUNTIF($L9,Declarations!$B$3:$B$6)*(Declarations!$C$3:$C$6="YES"))

Or try this:

=COUNTIFS(Declarations!$B$3:$B$6,Data!$L9,Declarations!$C$3:$C$6,"YES")

Thank you for the quick reply. I think my explanation was incomplete. When selecting NO for a particular color in the declarations page I only want those cells with that selected color to be disabled...And visa-versa for YES. For example if GREEN is checked NO in declarations page than the Green cell should turn white in Data(L16) and when selected YES the cell would turn green. Although I have not entered colors for Red and Blue, the same would be true. Currently every cell is turned Yellow in Data(Column L) when Yellow is selected YES in declarations page