Conditional Formatting Referencing Other Sheets
I'm building a process and want to add some automations to minimize errors. I have a column for "partner" that is a filled in via a form on sheet 1. I have a list of partners that we do not work with in sheet 2. I would like for the row (or cell) in sheet 1 to change colors if the form response is one of the names listed in sheet 2 (even better if it could just change a status without the color change being needed). Is this a functionality anyone else has managed to do?
I looked into cell linking and even some of the cell referencing options but I'm not seeing anything that quite matches up and would love to know if anyone has made this work.
Help Article Resources
Check out the Formula Handbook template!