Another frequent error is about using "$". Focus on understanding this issue, and your problem is solved
if you use this formula, =H3="yes" , and you want that all columns in this row to depend on column H, you have to lock the column in your formula, otherwise , excel will evaluate the next column formula as : =
I3="yes", the next column as =J3="yes", and so on.
Try: =$H3="yes", and excel will evaluate all columns involved in your range depending only for the value in column H.