Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Speed of Excel When Inserting & Deleting Rows | Excel Discussion (Misc queries) | |||
Inserting/deleting rows between worksheets | Excel Worksheet Functions | |||
inserting deleting rows?how do i get the other sheets to do the sa | Excel Discussion (Misc queries) | |||
anchor comments to cell while inserting and deleting rows | Excel Discussion (Misc queries) | |||
Excel links & inserting/deleting rows | Excel Discussion (Misc queries) |