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
|
|||
|
|||
CF goes crazy when deleting/inserting rows
This has happened to me many times, although I don't have a specific example
right now. When I have conditional formatting applied to multiple cells, then I either add or delete a row, the conditional formatting is completely changed. It now applies to many other cells. I haven't been able to make any sense of the changes that happen automatically. Is there a way to avoid this (other than not using conditional formatting)? Why doesn't it just delete the formatting for the cells that were deleted, rather than changing all the other formatting? Thanks |
#2
|
|||
|
|||
CF goes crazy when deleting/inserting rows
Are you using absolutes where necessary
$a$1 -- Don Guillett Microsoft MVP Excel SalesAid Software "DoubleZ" wrote in message ... This has happened to me many times, although I don't have a specific example right now. When I have conditional formatting applied to multiple cells, then I either add or delete a row, the conditional formatting is completely changed. It now applies to many other cells. I haven't been able to make any sense of the changes that happen automatically. Is there a way to avoid this (other than not using conditional formatting)? Why doesn't it just delete the formatting for the cells that were deleted, rather than changing all the other formatting? Thanks |
Thread Tools | |
Display Modes | |
|
|