I have created a spread sheet containing all of our SOP and Employees to track who is trained on what SOP. This spreadsheet has about 189 SOPs across the top (so I have about 189 columns), and about 20 employees down the right side. I enter a letter in the intersecting box to track what SOP revision the employee is trained on. At the very bottom I have a row that auto populates the current SOP revision letter corresponding to the SOP at the top of the column. I currently have to first column conditional formatted to flag when an employee is behind on their training; however, it seems that I will have to create another 188 conditional formats for each of the columns.



Thank you for your help