> Thanks Brian. I didnt make it clear - sorry about that. > > Let me clarify > > Day Date Time - value, value > > I rearranged the sheet so it reads Time Date Dat Value Value and then > sorted by time. I color coded but at that point - you are stuck at a > point where you cant get the values back into the same order as they > were before. You can order the columns by Date Time Date Value Value and > then sort by date but the times arent correct. But then again - it wont > matter as the cells that are color coded wont maintain the color after > the next sort. > > Hello Wade,
What I understood Brian was suggesting was to add a "service column" where you just have progressive numbers and use that column to restore the original order of the data once you have coloured them. So your spreadsheet would be Day Date Time - value, value -- "sequence number" And the operations: Sort by time colour sort by sequence number You can also rather easily write a macro that colours the backgrounds of the cells. You can probably put it together in 20 minutes or so depending on your experience with StarBasic. Cheers, Michele
