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

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.
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.
 
Upvote 0
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.
 
Upvote 0

Forum statistics

Threads
1,214,779
Messages
6,121,509
Members
449,036
Latest member
dudeinaghillie

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
Back
Top