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
You may use OFFSET for the gradient and icons
min:
=OFFSET($C$2, ROW()-ROW($A$1)-1, 0)
midpoint:
=(OFFSET($B$2, ROW()-ROW($A$1)-1, 0)+OFFSET($C$2, ROW()-ROW($A$1)-1, 0))/2
max:
=OFFSET($B$2, ROW()-ROW($A$1)-1, 0)
Thanks for your proposal.
It works when downloading your excel , but not if I copy and past to my excel: => Invalid formula