Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
can't copy conditional format formulas in Excel 2003
I've tried using the format painter as well as paste special - formats. The
results are an absolute reference to the conditional format formula I've copied from, and not reference to the cells I've copied the formula to. I have to go in and manually edit the formula. Please advise if there is an easier way. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
can't copy conditional format formulas in Excel 2003
Go in just one cell.
Then go in conditional formatting. For any of the cell references that you want to copy to other cells, click on them and press <F4 until they are correct. So $A$4 when copied will always relate to $A$4, but $A4 will relate to whichever row but always column A. Then go back out and copy the formatting on this cell to all the others. If you have done it right, the relative parts of the references will be updated for those cells. -- Allllen "pedalandrow" wrote: I've tried using the format painter as well as paste special - formats. The results are an absolute reference to the conditional format formula I've copied from, and not reference to the cells I've copied the formula to. I have to go in and manually edit the formula. Please advise if there is an easier way. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Format text Excel 2003 | Excel Discussion (Misc queries) | |||
Conditional Format Picture in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2007 Vs 2003 Conditional Format | Excel Discussion (Misc queries) | |||
Conditional format in excel 2003 based on another cell? | Excel Discussion (Misc queries) | |||
copy formulas without scrolling, excel 2003. | New Users to Excel |