Employee Training Database/Matrix

Highlighted
Occasional Visitor

Hi All

I have setup a list within my Human Resources site for a Training Register.

I have the columns setup as per the attached snapshot. With columns being

- Title (single text)

- Employee (drop down)

- Induction (date)

- Construction Card (URL - which i then link to the copy of the certificate in the employee document library)

...

 

I have some columns that are a simple Yes/No and some that are the URL with display text

 

I need to Format the columns so that some cells go red when the employee is required to have a certain licence or certificate but doesn't. However, not ALL employees are required to have the certificates so i dont want empty cells red, just some.

 

I was wondering if anyone knew how to do this or has setup a similar thing themselves in a different way?

 

Thanks

 

0 Replies