I am using a spreadsheet to track employees qualifications/certificates and their expiry dates, and I have it conditionally formatted to change colour based on approaching expiry date or expired.

I want to create a report/list of names in a separate tab to show me who has expiring/expired certificates for each qualification type, so I need it to pull the name data from the original sheet based on the date or colour of an adjacent cell. Is this possible and can anyone help with the formula required to do this? 

​I am using a spreadsheet to track employees qualifications/certificates and their expiry dates, and I have it conditionally formatted to change colour based on approaching expiry date or expired. I want to create a report/list of names in a separate tab to show me who has expiring/expired certificates for each qualification type, so I need it to pull the name data from the original sheet based on the date or colour of an adjacent cell. Is this possible and can anyone help with the formula required to do this?   Read More

​