Sort Dates from two different Columns into 1 combined column

[Xiiharu]

Hello All,

I'm looking to sort the dates of two different columns into one column. I have projects that have multiple dates on them I am wanting to order them so that I can see exactly when each one is due. I've attached an excel sheet to show what I would like the sheet to do, but this was all done by hand and I would like to automate it a bit.

[FlameRetired]

Hello Xiiharu. Welcome to the forum.

Try this in F2 and fill down until you get blanks.

Please Login or Register  to view this content.

Initially I made a mistake in this formula. This is corrected here: Then this in G2 and fill down the same.

Please Login or Register  to view this content.

[Xiiharu]

Is there a way to also keep the highlighting or to add a new conditional formatting option to dates? And is there a way to hide dates? Like anything from 2-20-20 and before.

[FlameRetired]

First extend the range references in column G out to row 10. Like this.

Please Login or Register  to view this content.

For the colors use Conditional formatting by formula. Select F2:F18. Apply this formula for Blue

Please Login or Register  to view this content.

and this one for Pink

Please Login or Register  to view this content.

To hide dates <=2/20/2020 use Conditional Formatting by formula again. The formula

Please Login or Register  to view this content.

and set Custom format numbers ""

It's all done in the attached so you can see what I mean.

[Xiiharu]

I've put in the formulas that you gave me and I've been trying to get the conditional formatting to work. Some of mine aren't applying the formatting and I don't know why. The combined list could go for a long while so can it just apply to the whole row? Also the lists for B date, F date, and Project name could have a lot. Can that selection be expanded.
Regarding the date formula. I was unclear and i'm curious if it is possible to have the list not show any dates that are less than the current date? So for example, It would show all dates of today and later, put remove any that are before today.
Sorry for not being as clear in the original post. Your help has been great.

[FlameRetired]

OK. Still not clear on the 'follow through'. What does this now imply for the list of Project names? Are the ones corresponding with dates <=2/20/2020 to also be ignored?

[Xiiharu]

Yes, I would like the dates and project names to be removed as the day it lists has passed. If this can't be done i'm not truly worried about it. The main thing is I am trying to get it to list the projects and dates in chronological order, and to have the dates from the rows keep their colors. The list of dates and projects can be upwards of 30 entries long, with each project have it's two dates.

[FlameRetired]

Thank you. That's clearer.

Delete the CF rule for <=2/20/2020. The others Blue/Pink remain the same. I would discourage applying CF rules to whole columns/rows. CF are super volatile and they are resource hungry. Once you define the initial range that will expand as formulas are extended downward.

Change the formula in F2 to

Please Login or Register  to view this content.

and fill down. The formula in column G remains the same.

[Xiiharu]

I was able to get the conditional formatting to work with my lists based off of your help from the last reply. What I'm trying to do with the dates is something like the image below.

Date example.PNG