Forum Discussion

TEagle's avatar
TEagle
Occasional Reader
Oct 08, 2025

Data Validation Conditional Formating

I have a shared spreadsheet where coordinators enter staff codes for particular tasks they would like them to do (it's not a timesheet, just a future planning tool). I have set up a data validation to warn them if they enter a staff code that is not in the list, however if someone leaves after their code has been entered, the validation doesn't re-check so the now-invalid code remains happily in the spreadsheet. I need the cells to highlight if the staff code is not in the list.

Does anyone know if this is possible?

Currently, I need to search for each code as someone leaves and manually remove them from the spreadsheet and then ask coordinators to re-enter new values. It would be great if it would just flag them in red when I remove them from the staffing list and coordinators can see if there is (now) an error that needs fixing.

Not sure how to attach a file as it's not 'link'able with a URL, so here's screen shots:

user interfaceformulas to calculate the total hours based on the task typeconditional formatting to highlight the table on the right, or when someone does a seazrch for one particular staff member using the box below the 1st table

 

 

No RepliesBe the first to reply

Resources