Adding Rows

[leimst]

Hi,

Is there a good way to add rows to a spreadsheet and keep all formulas and
conditional formatting?

I converted a range to a "list" so that it is now highlingted in blue and I
get the asterisk in the bottom left hand corner whenever I click inside of
the "list". However, when I make entries in the last row where the asterisk
is, I find that it does not bring my conditional formatting with it.

Is this a known issue with Excel?

Would the best way to add rows to a Protected sheet where the user doesn't
know the password be to create a Macro and assign it to a button that the
user could use so that the user could add rows, would not need to know the
password, and the conditional formatting would be maintained as well as the
formulas?

Thanks for any help,

Brian

 

[Joerg Mochikun]

Works fine in Excel2003. When adding a row to a list Excel keeps the
conditional formatting. Not sure how Excel determines which format to apply
if cells are formatted differently within a column: In my tests Excel took a
majority vote: If more than half of the cells in column were formatted in a
particular way, the added cell would inherit the format. Are all your cells
formatted the same? If yes and the format is still not carried over: what is
the conditional format that you are using?

As for the 2nd question: Don't know how it relates to the first. And yes:
It's not only the best way, it's probably your only option. Make sure to
password protect your VBA code since it will contain the worksheet pw in
plain text and make sure that the user cannot interrupt the macro. And
lastly: make sure that the user doesn't know how easy it is to break the
protection of a worksheet ;-)

Cheers,
JM

 

[ryguy7272]

The list feature in my Excel DOES copy the formatting down as new
rows/records are added. Maybe you need to close Excel (hit ctrl+alt+delete
and make sure it is not showing under 'Processes' in the Task Manager). Then
reopen and try again. I get some weird Excel behavior once in a while. I
think it has to do with the memory. Clear the memory and restart.


Regards,
Ryan---