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

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).

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

Chatnoir11;210107 Wrote:
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).

Hi,
are your formats defined by Conditional formatting?


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=57661

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

Edit/ Paste Special/ Paste/ Formulas
--
David Biddulph

Chatnoir11 wrote:
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).

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

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?


"Pecoflyer" wrote:


Chatnoir11;210107 Wrote:
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).

Hi,
are your formats defined by Conditional formatting?


--
Pecoflyer

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

*Adding your XL version* to your post helps finding solution faster
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=57661

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

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

"David Biddulph" wrote:

Edit/ Paste Special/ Paste/ Formulas
--
David Biddulph

Chatnoir11 wrote:
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).