Apr 29 2023 01:35 PM
Good evening.
I am creating an employee schedule.
below my daily shifts in each column I've listed the available employees for the day.
Is there a way for me to remove or highlight a name from the available section when I add it to the schedule section. And to add or un-highlight light the name in the available section if I remove it from the schedule section.
Many thanks.
Apr 29 2023 09:20 PM
@vtwayfaringman The attached file contains a simple example of how you could do this with conditional formatting. It highlights in green who's available and warns in red if you accidentally entered the same name more than once in the schedule.