Cell Fill Format & Sort Question

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I have a column with 144 rows. In alternating rows, I have a solid fill to
make the spreadsheet easier to read, especially when printed. However, when
I sort one of the columns, the fill formatting changes. Is there a way to
sort without changing the fill formats?

Thanks!
 
Use conditional formatting to fill...
Choose the option FORMULA IS and enter the formula
=MOD(ROW(),2)=1
or
=MOD(ROW(),2)=0

as the condition to format
 
Use conditional formatting to fill...
Choose the option FORMULA IS and enter the formula
=MOD(ROW(),2)=1
or
=MOD(ROW(),2)=0

as the condition to format
 

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

Series fill only copying and fill series greyed out 1
Remove date format? 3
Fill without formatting 1
Excel Macro to automatically go to the right of the last colored cell 0
Excel Conditional Formatting 1
Format Cells - Fill colour Help 11
Can I sort values only & leave orginal cell formatting? 1
"Fill" Conditional Formatting? 5

Back
Top