Cell Fill Format & Sort Question
 

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!

Cell Fill Format & Sort Question
 

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

"Scott" wrote:

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!