How can I return a unique list of names and fill in a calendar from associated person dates from a table of data

[cyrous0425]

Here's the link of my excel sheet https://drive.google.com/open?id=1A4NIA-UMu1PoJ7K8r1z3LyTrAwQZe_gn.

So From column A:F where I entered the data. I want to filter the unique value in column 5 and put in in column G and apply a conditional formatting as pictures shown?
Thank you.