Use

=IF(AND($E$9="yes",$G$9="yes",$J$9="yes")


In article ,
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)"