| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy Conditional Formatting down rows
New to Office 2007, but am very frustrated. When I copy a cell's formatting
(either by paste/special/formats or format painter) the conditional formatting is not using the relative cell row reference but instead always referring back to the original cell even though I am not using the absolute $ reference. For example: CF = A10100 (in cell A10) when I copy the format to B10 CF = A10100 If I copy the format to B10:F10 CF in all cells = B10100 What is going on?? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy conditional formatting only? | Excel Discussion (Misc queries) | |||
| copy conditional formatting | Excel Discussion (Misc queries) | |||
| Conditional Formatting Copy down Rows | Excel Worksheet Functions | |||
| How to copy conditional formatting | Excel Worksheet Functions | |||
| Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Threaded Mode
