Ι want entire row to be moved when I sort by date.
Greetings everyone,
I use excel to track the tasks of a small office. All the "to-dos" are in column b, the dates in column c, and column a is kept for colorcoding the tasks according to who has to do them. So all the cells in column b are filled with some color or other. I use row 1 for naming the columns and having filters. The problem: when I use the sort by date filter, the colors column a do not get rearrange, following the contents of the other row. Is there any way to work around that?
Last edited by marianna.ark; 07-03-2018 at 03:50 AM.
Can you attach a small sample showing the issue?
Go Advanced -> Manage Attachments -> Upload
Heres a small excell table I made, replicating the issue. The events/dates are not in chronological order. If u sort them out using the filter, the assigned colors in front of each event dont move along with the tast but stay where they were.
I have not opened your file, as I am away from my PC, but if you have assigned colours to the cells themselves, it won’t work as you want. You should be using conditional formatting instead.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
If you create a table which includes Column A then the sorting on the entire row will work.
See the attached.
Thank you so much! I will also look up how conditional formating might effect this issue, because it might be useful some other time.
As has been stated, a table will solve this for you, but conditional formatting would automate what I assume is a manual process at the moment.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks