Solution for Why is my conditional formatting rule not working?
is Given Below:
I have a google sheet with information in cell A and a check box in cell G (other filled cells in between). I have set a custom rule to change the colour of the row when the checkbox has been ticked. The rule works for all 2000 rows eg when checkbox is ticked in any row it works, however only cell A changes colour, not the whole row.
Why is this only changing column A?