Forum Discussion
remove cell if value found in same colum
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 th...
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.