Conditional Formatting help
Hi there,
I have a sheet where I list plays in columns, and then in each row there will be names of people being considered for roles in each play. Each column with a play has another next to it with a checkbox (e.g. Column A is XYZ play, and Column B is a checkbox; Column C is JKL play, and Column D is a checkbox, etc.)
When I have decided that a person is confirmed in a role, I check the box next to their name. I have the sheet set up currently with conditional formatting so that when I check a box, that cell and the named cell to its left turns green. (=$B2=TRUE). So far so good.
What I would like to do is this: there will be other cells in the sheet that the same person's name shows up in, because most people are being considered for multiple roles. When I have cast someone in a certain role, and checked their box (which turns that pair of cells green), I would like for every other instance of that person's name to be struck through.
My understanding is that, essentially, I need the entire sheet to be on the lookout for duplicates, but to only strike out a duplicate once a single iteration of it has either a) turned green, or b) had it's adjacent cell checked (i.e. value=TRUE).
Any advice on how I might accomplish this?
Thanks!