Home |
Search |
Today's Posts |
#1
|
|||
|
|||
relative references when cutting/pasting
Hi,
I have a cell, say A1, with conditional formatting based on the contents of the cell on the same row, say, 3 columns to the right, specified with a relative reference ($D2). When I copy the cells with the conditional formatting up and down, the cell that determines the formatting goes with it, which is just what I want. The formatting for A5 is based on D5, etc. But I want my users to also be able to cut/paste these cells if they wish and in this case, the formatting does not follow. For example, If I cut cell A1 and paste to A5, the formatting is still based on D1, not D5. I would think there's a way using indirect references, but I'm unable to see the answer. Thanks, Barnett |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want chart source data to be relative references, not absolute. | Charts and Charting in Excel | |||
Relative Cell References within VBA code | Excel Discussion (Misc queries) | |||
macro vba relative references | Excel Worksheet Functions | |||
relative sheet references ala sheet(-1)!B11 so I can copy a sheet. | Excel Discussion (Misc queries) | |||
How can I enable the "Record Using Relative References" option in. | Excel Discussion (Misc queries) |