Hi there!
I've tried to find a way to do this simply, but I'm stumped. I have a rotating roster of people who will be assigned to different tasks. They can't do multiple tasks on the same day. I want to make sure I'm not duplicating names across each row.Conditional formatting works across a row, but would I need to highlight each row separately to keep it from trying to compare down the column?
I know I could use COUNTIF, but I'd need to set up a complex formula to compare every single cell to each other cell in the row. I could also do an IF formula along the same lines (if D1=E1, etc). I'm hoping there's a simpler way that I haven't found.
Any thoughts? I uploaded a workbook with sample values and some comments on what I've tried.
I'll be happy to clarify if my question is as confusing as I think... Thank you!
I've tried to find a way to do this simply, but I'm stumped. I have a rotating roster of people who will be assigned to different tasks. They can't do multiple tasks on the same day. I want to make sure I'm not duplicating names across each row.Conditional formatting works across a row, but would I need to highlight each row separately to keep it from trying to compare down the column?
I know I could use COUNTIF, but I'd need to set up a complex formula to compare every single cell to each other cell in the row. I could also do an IF formula along the same lines (if D1=E1, etc). I'm hoping there's a simpler way that I haven't found.
Any thoughts? I uploaded a workbook with sample values and some comments on what I've tried.
I'll be happy to clarify if my question is as confusing as I think... Thank you!
