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?