I am using columns B through H. When column F contains "yes" that cell formats in blue. When column G contains "yes" it formats in pink. When column H contains "yes" it formats in yellow.

All of the cells in that row, B through H, need to format yellow whenever column H contains, "yes." If Column H does NOT contain "yes," I would like column F to remain blue, and column G to remain pink.



I am getting really strange results. If I use =H3="yes" and apply it to =$B$3:$H$77, only F, G and H format in yellow, even though the other columns are within that range. Furthermore, I lose the blue and pink formatting in rows that have no "yes" in column H because everything turns yellow.

I tried various other ranges , or popped the conditional formatting into different cells, and found random cells displaying in yellow - sometimes these cells wouldn't even be in the same row as H="yes". However, I could never get the entire row to turn yellow no matter what I did.

The only other conditional formatting applies gray formatting to blank cells. Only columns E through H would ever be blank, so I used range =$E$3:$H$77. I don't know if conflicting conditional formatting is causing this, or if I just don't understand how to apply it. Can you please advise?

Thanks!

To fix conflicting conditional formats, Conditional Formatting > manage Rules. Select a rule and use the Move Up or Move Down button to change the order that the rules are enforced. The top rule will override the others.

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.

That was perfect! Thank you!