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

[jason11972]

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?

 

[jason11972]

bump

 

[jason11972]

bump again.

 

[jason11972]

bump again. Does nobody know how to do this? Or is my question just unclear?

 

[VoG]

Have you tried recording a macro to do this?

 

[jason11972]

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]

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.