I have a column (Special characters) that contains special characters, one character per cell, that aren't allowed in another column (Product Name). I want to format the Product Name column to color fill if a cell contains any of the special characters from the Special Characters column. Can this be done?
Thanks!
Bookmarks