Hi everyone,
I'm looking to write conditional formatting rules for cells that look at another cell's value in comparison to many values in a table titled TableFormatting. If the referenced cell equals a value in one of the table's columns one of eight different formats should apply to that cell. I've attached a simplified version of the workbook that helps illustrate my situation.
I've tried several variations of rules for the conditional formatting with no luck as of yet so I'm wondering if someone has an elegant solution.
Thanks so much and let me know if anything I've explained requires further clarification.
Bookmarks