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

C

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

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying a formula with an increase of more than 1 6
How do I copy conditional formatting only? 5
Series fill only copying and fill series greyed out 1
dragging a formula in a filtered table 1
Expand Conditional Formatting to all Rows 7
How do I automatically hide "FALSE" rows? 14
vlookup formula not copying 16
can i link 3 rows together and sort them as one unit? 4

Top