Hi I have a spreadsheet with a list of names then 3 colums of yes/no drop down boxes in the next column I'd like the cells to either be red or green, where green means that the 3 preceding cells are all yes and red meaning that one of the three is a no, the list is getting quite long so this would make it a lot easier to see where the rows with all yes are.

Something like this:

If b2=Yes and c2=Yes and d2=Yes then fill=green else fill=red

Except I need it so Excel likes it lol