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