The title says it all really.
I need to know how to make one cell say either 'Yes' if 3 other cells say yes or 'No' if they dont.
i.e.
If A1, B1 and C1 says 'Yes' (selected from a drop down list) I want D1 to say 'Yes' and be coloured green.
If A1, B1 and C1 says 'No' (selected from drop down list) I want D1 to say 'No' and be coloured Red.
Any help will be greatly appreciated.
Thanks in advance,
Tom.