I've got a similar problem but doing color formatting. I have a spreadsheet that has a series of names in column A. Column B, C, and D represent various attributes and are either "Yes" or "No". So how do I change the color of cells in column A as follows:

If B, C, and D are all Yes, A is green
If B, C, and D are all No, A is red
If B, C, and D have any combination of Yes and No, A is yellow.