The formula:
=IF(AND($E$9="yes",$G$9="yes",$J$9="yes"),1,0)
will yield a 1 or a 0 in the cell where it is located based on the contents
of the three cells listed. If you then go to Format / Conditional Formatting
and make the cell one color if the result is 1 (one condition) or another
color if the result is 0 (a second condition).

"egarcia" wrote:

I want a cell to be colored if E9,G9,&J9 all have yes entered in, but the
formula I am using does not color the cell.

="if(and($E$9=""yes"",$G$9=""yes,$J$9=yes)"