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
I am not sure I fully understand your objectives, so let's start with a simple 'solution'.
Use Format Painter to select the conditional format, then apply it to each target range separately.
Any of the limits may be adjusted using the dialogue boxes you show, as can the colours.