So I have this custom formula for conditional formatting in google sheets
=(A2 <> "")
I want to copy this rule to all the cells in a row. When I try to apply it to the whole row it doesn't work.
This happens:
only the cell next to the cell with text has its color changed
I want the whole row to change color if I have text in the A2 spot.
Thanks!