Calendar for advertising release for social media

On the first sheet of the Google spreadsheet, there is a record of all purchased advertising, indicating which advertisement is being promoted and which account is being used.
The second sheet contains a calendar.
8 accounts. IMPORTANT that the same advertisement does not repeat in the same public. Therefore, when the manager plans advertising for a certain day, and the table detects a match, the column is highlighted, and a warning appears in the calendar.