Share via

Condition Formating

C Jensen 1 Reputation point
2022-07-25T16:32:49.69+00:00

224541-capture-2.png

Hopefully the image loaded correctly this time. I'm trying to set up an excel sheet to track training progress. We use milestones to indicate when the training should be done based off the date of when a new member arrives. Column A is the number of months, column B is the due date. D2 is the date of when they arrived and is what the dates in column B are calculated from. In order for someone to be fully qualified in a task, the trainee (column I) and trainer (column J) must initial in their blocks. So, here's what I'm trying to do...

I've set up column B to project due dates based off the date they arrived and the number in column A =EDATE($D$2,A6) Easy enough, now how do I set it up to turn green when the trainee and trainer initial their blocks? I can't use character specific due to initials always being different. Any help would be appreciated.

Microsoft 365 and Office | Excel | For business | Windows

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.