Conditional format based on external cell value

Question

want to format a row based on the contents of a single cell. I.e., if the answer to Q6 is "yes," I would like to turn row 6 green. have experimented with numerous

=INDIRECT(ADDRESS(ROW(),17))>0

and

=INDIRECT(ADDRESS(ROW(),17))="yes"

Answer 1

Use a rule with the formula =$Q6="Yes" and apply it to all the rows in question, starting with row 6.