Ι 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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
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