Hi,
I have a Skill Register Spreadsheet that some has asked some help on.
I have been able to add the conditional formatting so that if someones "card/skill" is either out of date or due for renewal within the next 30 days that it will should in highlighted Yellow on the cell.
This has worked well, however they have come back to me asking if it is then possible to filter by colour.
This is fine as I am using Excel 2010. However as there are multiple columns I am hoping to put a formula into column D (Expiring Cards Check) which will allow me to have a text result telling us whether or not the persons skills are current/ok, or need to be updated.
Is there a way to be able to do this formula so that if the Yellow Cell background is present within the row that column D will return "UPDATE" and if not then "OK" so that we can then filter on these 2 words to get a list of who is needing updated skills/cards and those who don't need to update their skills/cards?
I have an IF formula in there, however as some of the columns are blank (because the person doesn't have nor need those skills/cards - it always returns "UPDATE".
I have attached for reference.
Thanks.
Matt
Bookmarks