how do I keep rows' formats when copying a formula?

[Chatnoir11]

Hi again.

I have an existing worksheet and some rows are red font, others black, some
rows are highlighted, others not. All on purpose. Now I want to add a formula
to a column and drag it down to all the rows, but my formatting then goes
cattywampus. How do I fill the formula down all the rows without messing up
the formatting of those rows?

(Right now I go back manually and fix them, but every time I change the
worksheet, this gets ridiculous).

 

[Pecoflyer]

Hi again.

I have an existing worksheet and some rows are red font, others black
some
rows are highlighted, others not. All on purpose. Now I want to add
formula
to a column and drag it down to all the rows, but my formatting the
goes
cattywampus. How do I fill the formula down all the rows withou
messing up
the formatting of those rows?

(Right now I go back manually and fix them, but every time I chang
the
worksheet, this gets ridiculous).

Hi,
are your formats defined by Conditional formatting

--
Pecoflye

Cheers -
*'Membership is free' (http://www.thecodecage.com)* & allows fil
upload ->faster and better answers

*Adding your XL version* to your post helps finding solution faste

 

[David Biddulph]

Edit/ Paste Special/ Paste/ Formulas

 

[Chatnoir11]

No, they were highlighted, for example, as orders came in. It is a very live
spreadsheet. Using only conditionally would help here, wouldn't it?

 

[Chatnoir11]

Ahhh....right.. dragging is just such habit... thanks!!