Auto-sorting data and it's affect on conditional formatting

jason11972

New Member
Joined
Sep 21, 2006
Messages
11
I have a spreadsheet with files listed on it where I'm constantly switching the dates for each file. How do I fix it so that every time I change a date it will auto-sort the file so that all of them stay in chronological order? And when it does that..will it maintain the conditional formatting I've put on each of the seperate rows of data?
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650

ADVERTISEMENT

Have you tried recording a macro to do this?
 

jason11972

New Member
Joined
Sep 21, 2006
Messages
11
No. I was told that might be involved in the solution I'm looking for, but I dont know how to go about doing it.
 

VoG

Legend
Joined
Jun 19, 2002
Messages
63,650
Tools > Macro > Record new macro.

Do your sorting then click on the stop (square) on the macro recorder toolbar.

Pressing ALT+F11 will open the Visual Basic Editor so you can see the code created. You can post that here and someeone hopefully will clean it up for you.
 

Forum statistics

Threads
1,136,269
Messages
5,674,743
Members
419,525
Latest member
helensesc

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top