Thread
:
CF goes crazy when deleting/inserting rows
View Single Post
#
2
October 2nd, 2008, 09:33 PM posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 6,167
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
Don Guillett
View Public Profile
View message headers
Find all posts by Don Guillett
Find all threads started by Don Guillett