Excel – Automation

I want to do a conditional formatting with date criteria being matched from one sheet to another sheet and that date gets highlighted if a comment is not inserted in the respective cells and also need automatic insertion of rows when a condition is met (all the headings are filled for that specific individual and then it calls the program to automatically insert a new role with that person’s name on it