Conditional Formatting

I would like cells in a google sheet to be filled with color based on dates in another cell. The cells in the appropriate "Month" column should be filled with color between the start and the end date of the project. If the start date is in the past, it should start with the current month. The color should change for each person/consultant.