Bretters_at_work
New Member
- Joined
- Aug 22, 2019
- Messages
- 2
I am struggling with finding a way to highlight cells in my data preferably using conditional formatting in colour for sorting the following or flagging in some sort. My actual data source has about 8,000 people so manual sorting is not needed and I need to make sure I record each step for future pulls of data.
I am looking for who is done all their training. For example wanda.roman@work.com has completed all she needs for her role. So I would want her roles to highlight in “green” and mark in the column completed Yes
Next I want to see what courses were they supposed to be scheduled into but they haven't registered yet? For example jim.smith@work.com has a role of Referral coordinator but has not registered for the course. And bill.jones@work.com has a role of template builder but has not registered for it either. I would like to highlight those course in “red” and mark in the column completed No.
As a bonus is there a way I could highlight those that took a class not needed for their role for example bill.jones@work.com has taken the supervisor course but does not have that role. Could I highlight his name in “yellow” or I could add in a column that says extra courses taken similar to the above and just say yes or no
I have 3 tables already named
Table 1 Roles is the Roles is the listed roles for the individuals, They can have multiple roles
Table 2 Course is the courses that are listed is the needed education for their roles some roles have multiple courses needed.
Table 3 Learning is the courses taken so far by the individuals in Table 1.
Table 1
<colgroup><col><col><col span="2"><col></colgroup><tbody>
</tbody>
Table 2
<colgroup><col><col></colgroup><tbody>
</tbody>
Table 3
<colgroup><col><col></colgroup><tbody>
</tbody>
I am looking for who is done all their training. For example wanda.roman@work.com has completed all she needs for her role. So I would want her roles to highlight in “green” and mark in the column completed Yes
Next I want to see what courses were they supposed to be scheduled into but they haven't registered yet? For example jim.smith@work.com has a role of Referral coordinator but has not registered for the course. And bill.jones@work.com has a role of template builder but has not registered for it either. I would like to highlight those course in “red” and mark in the column completed No.
As a bonus is there a way I could highlight those that took a class not needed for their role for example bill.jones@work.com has taken the supervisor course but does not have that role. Could I highlight his name in “yellow” or I could add in a column that says extra courses taken similar to the above and just say yes or no
I have 3 tables already named
Table 1 Roles is the Roles is the listed roles for the individuals, They can have multiple roles
Table 2 Course is the courses that are listed is the needed education for their roles some roles have multiple courses needed.
Table 3 Learning is the courses taken so far by the individuals in Table 1.
Table 1
| Complete | EMAIL_ADDR | ROLE | ROLE2 | ROLE3 |
| jim.smith@work.com | Admitting Clerk | Registration Supervisor | Referrals Coordinator | |
| wanda.roman@work.com | Template Builder | Referrals Coordinator | ||
| bill.jones@work.com | Admitting Clerk | Template Builder |
<colgroup><col><col><col span="2"><col></colgroup><tbody>
</tbody>
Table 2
| Role | Course |
| Admitting Clerk | Basic Access |
| Admitting Clerk | Registration |
| Referrals Coordinator | Referrals |
| Registration Supervisor | Basic Access |
| Registration Supervisor | Registration |
| Registration Supervisor | Supervisor |
| Template Builder | Templates 101 |
<colgroup><col><col></colgroup><tbody>
</tbody>
Table 3
| Course_Name | Email_Address |
| Basic Access | bill.jones@work.com |
| Registration | bill.jones@work.com |
| Supervisor | bill.jones@work.com |
| Basic Access | jim.smith@work.com |
| Registration | jim.smith@work.com |
| Supervisor | jim.smith@work.com |
| Referrals | wanda.roman@work.com |
| Templates 101 | wanda.roman@work.com |
<colgroup><col><col></colgroup><tbody>
</tbody>
