Hi,

I have conditional formatting set-up where a range of cells will change
colour based on values in another couple of cells.

The rule was along the lines of:
Cell Value Is between =$D$134 and $E$134

This worked fine however in order to allow me to copy the rule to other rows
I removed the '$' signs (based on a recommendation in another post).

Unfortunately after copying the formula now no longer works. The rule is now:
Cell Value Is between =D134 and E134

Can anyone help by explaining what the '$' does and how I might be able to
fix this as I need to be able to copy the rule to a several rows without
changing each time.

Thanks
CW