Forum Discussion
Copy conditional formatting based on another cell.
=$AD1="YES"You can try the above rule for conditional formatting and apply it to the range:
=$A$1:$L$500
=$AD1="YES"You can try the above rule for conditional formatting and apply it to the range:
=$A$1:$L$500
OliverScheurich 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.
- Fantastic!! Great help! Thank you Hans!
