How to alert regarding a duplicate value within a row?
Hi I would like to add some sort of alert or conditional formatting, but I'm not sure how to accomplish this. For the columns impacted they are all dropdown single select columns. I want some sort of alert, could be as simple as highlighting the row, if a value in "Faculty on PTO" appears in any other column for that specific row. For instance, if Dr. Smith is on PTO for that day, he/she should not be listed as on call for any of the options.