A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Condition Formating
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.