Thanks to a wonderful member here, I learned how to easily add conditional formatting to multiple columns in a row (like A,B,C,D,E).
I have one more similar but not exact question.
I have multiple columns, but I need the same formatting, but the columns are not sequential.
The same formatting needs to be in A, C, E & G
For instance, the formula is:
A3>0
and it Applies to:
=$A$3:$A$467
Column B has different formatting, but column C chould have the same formatting noted for column A.
How can I achieve the Formatting for A & C in only one formatting line?
Had a look at your previous file where the “Applies to” range was $B$4:$F$274 for all rules.
Now, let’s assume you want to apply one rule to columns A and C and another rule to B and D.
Then set the “Applies to” range for the first to: $A$4:$A$274, $C$4:$C$274
and for the other one to: $B$4:$B$274, $D$4:$D$274
Thus, list column ranges separated by a comma. Give it a try and come back if you run into a problem.
Thank you very much!!
