Hello
Hope you can help
I want to colour say, C1 if A1 OR B1 > 0
I want to however repeat this down the column so ...
C2 is coloured if A2 or B2 > 0
C3 is coloured if A3 or B3 > 0
I can do it for one row, but can't work out the formula for it to apply to the whole column
When I do it, either nothing happens or each cell in column C focuses on just A1 and B1 instead of the corresponding cells in column A or B
Thanks!
Hope you can help
I want to colour say, C1 if A1 OR B1 > 0
I want to however repeat this down the column so ...
C2 is coloured if A2 or B2 > 0
C3 is coloured if A3 or B3 > 0
I can do it for one row, but can't work out the formula for it to apply to the whole column
When I do it, either nothing happens or each cell in column C focuses on just A1 and B1 instead of the corresponding cells in column A or B
Thanks!