How to highlight a row in a color based on text in a cell on that row?

I have a spreadsheet I use to mark inventory as received back into a warehouse. We use 3 different colors on the Line Item's row to say if it is back in the warehouse, being return or back in the warehouse. Green is not in the warehouse, orange is coming back and yellow is in the warehouse.

So, what I want to do is make it so when I put a "YES" in Cell Q8 it highlights A8-R8 in orange and doesn't change anything else.
And If I put a YES in BOTH Q8 and R8 it highlights cells A8 through R8 in yellow and doesn't change anything else.

And of course, I would need to apply this to every row

Is there a way to do this?

Use conditional formatting on range A8:Q8. Use formula:

Formula:

Please Login or Register  to view this content.

Format to suit.

Okay, add two conditions to your conditional formatting:

1:

Formula:

Please Login or Register  to view this content.

Format to suit, select "Stop if true"

2:

Formula:

Please Login or Register  to view this content.

Format to suit

You can apply this conditional formatting to the whole range you want it to apply to - the column references are absolute, the row references relative, so you can simply change the "Applies to" range for each rule.

Conditional formatting will always override manual formatting - that's the point.

I'd suggest if you want a manual override to set up another conditional formatting rule, based on a manual entry in another column (make it the first rule, set Stop if true).