Hello
I have a conditional formatting which checks the value of the top cell of a column and accordingly formats the whole column.
The code is:
FORMULA: =$A$1=1
APPLIED TO: $A:$A
The problem is that I want this to work for each of the other columns but the columns already have other static and conditional formatting applied to it so I cannot really copy/paste the formatting.
Is there a way to do that?
Thanks!
I have a conditional formatting which checks the value of the top cell of a column and accordingly formats the whole column.
The code is:
FORMULA: =$A$1=1
APPLIED TO: $A:$A
The problem is that I want this to work for each of the other columns but the columns already have other static and conditional formatting applied to it so I cannot really copy/paste the formatting.
Is there a way to do that?
Thanks!