Forum Discussion
Copy conditional formatting based on another cell.
Hi all,
I need some help with copying a conditional format I've created.
Simply explained the formula applies to range A1:L1. When cell AD1 shows YES I want the range to turn green.
Formula: =$AD$1="YES"
Now I would like to copy this to next 500 lines, however every time I try to copy the format it doesn't change the cell its based on. The next row should be A2:L2 based on AD2 but when copying it keeps AD1 as the cell it bases it on.
Any tips?
All help us much appreciated!
Thank you!
=$AD1="YES"You can try the above rule for conditional formatting and apply it to the range:
=$A$1:$L$500
4 Replies
=$AD1="YES"You can try the above rule for conditional formatting and apply it to the range:
=$A$1:$L$500OliverScheurich thanks man! That has worked a treat!
What do the dollar signs actually do? Because that's all we've changed I suppose.
Thank you!
A $ sign in a cell reference makes the reference absolute, i.e. it will not change when you fill or copy to other cells. Without it, a reference is relative, i.e. it will change.
For example, =$A$1 will remain the same when you fill down or to the right.
=$A1 will change to =$A2, =$A3 etc. when you fill down, but it will remain the same when you fill to the right.
=A$1 will remain the same when you fill down, but it will change to =B$1, =C$1 etc. when you fill to the right.
=A1 will change to =B2, =C2 etc. when you fill down, and to =B1, =C1 etc. when you fill to the right.
