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

Select the cell you already have conditionally formatted.
Press Conditional Formatting and then Manage Rules. In the field 'Applies to' write the range with all your columns. OK.

The problem is the formatting of column D is dependent on the letter in cell D11, Column E is dependent on the letter in cell E11, and Column F on the letter in F11. If I just tell the conditional formatting to apply to all cells in column D,E, and F, it will base the conditional formatting of Column E and F on the letter in cell D11.

Attached Images

formatting example.PNG (10.3 KB, 18 views)

Couldn't you upload at least part of the Excel file including the cell that you have conditionally formatted?

Here is a small example. I have the conditional format in the column b only

Attached Files

Conditional format example.xlsx (10.3 KB, 20 views)

Is it like shown in the attached?

Attached Files

CF_2.xlsx (10.3 KB, 13 views)

That is exactly what I needed. Thank you.