Forum Discussion
Solved
Conditional formatting with 3 color scale. Copy format to other cells
Dear experts, How can I copy the conditional formatting of the 1st row to subsequent rows taking into account the values of the corresponding row and not the 1st one. Thanks in advance for yo...
Sorry, I didn't test properly. It works differently compare to couple of years ago. Workaround could be
- apply the rule to $A$2 only
- using format painter apply to other cells but A3
- in CF manager duplicate rule for A2 and apply it to A3
Perhaps you shall use semicolons in formula instead of commas. Could you share your file?
I sent a message to you with the excel.
