Hello,
I have an Excel sheet containing a list of items and their attributes. Each item can have up to eight unique attributes from a common pool of over 20 attributes. The item's name is in column A, attribute #1 in column B, attribute #2 in column C, etc. (Please see the attachment for a sample table in this format)
I would like to use conditional formatting to highlight all item names (in column A) that have a specific attribute (let's say "R", for example). I know how to do this using a series of nested IF statements, but that is messy and difficult to modify when needed. Is there any simpler way of doing so?
-Sklar
Bookmarks