I have set a conditional rule so that if a specific cell equals "y" then the cell background is changed to green.

Is there a way to apply this rule so that it will change the background colour for the row the cell is on?

| improve this question | | | | |

Pretty much.

Assuming the value is in column A.

  1. Format>Conditional Formatting
  2. Enter A:J under Apply to Range (or extend beyond J if you need to)
  3. Format cells if Custom formula =$A:$A="y"

That'll get you this example.

| improve this answer | | | | |

Not the answer you're looking for? Browse other questions tagged or ask your own question.