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?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityI 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?
Pretty much.
Assuming the value is in column A.
A:J
under Apply to Range (or extend beyond J if you need to)=$A:$A="y"
That'll get you this example.