remove cell if value found in same colum

Copper Contributor

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.

1 Reply

@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.

Screenshot 2023-04-30 at 06.17.21.png