#1
|
|||
|
|||
Conditional Formating?
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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.
|
#4
|
|||
|
|||
Couldn't you upload at least part of the Excel file including the cell that you have conditionally formatted?
|
#5
|
|||
|
|||
Here is a small example. I have the conditional format in the column b only
|
#6
|
|||
|
|||
Is it like shown in the attached?
|
#7
|
|||
|
|||
That is exactly what I needed. Thank you.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Conditional formating | MJS16 | Excel | 16 | 12-01-2016 01:09 PM |
Conditional Formating | MaineLady | Excel | 2 | 10-30-2016 02:08 PM |
Conditional Formating | Aseren | Excel | 14 | 02-18-2016 01:05 PM |
Conditional Formating | MaineLady | Excel | 1 | 11-05-2014 06:37 PM |
more Conditional Formating | princeofsadness | Excel | 2 | 09-05-2011 02:14 AM |