If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Conditional format will not work without $ (removed to allow copyi
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 |
Thread Tools | |
Display Modes | |
|
|