CODEWITHSUNDEEP
excelconditional-formatting
Bevan
Bevan

Reputation: 584

Conditional Format based on column header

I have a list of products in Column A, csv lists of attributes in column B, then a column for each unique attribute across the sheet to column BI.

I want to highlight the cells in each column, that appear in the csv for that row. I'll try and explain with this example:

ColumnA          ColumnB          ColumnC     ColumnD      ColumnE     etc...
Products         csv List        Attribute1  Attribute2   Attribute3   etc...
Product1  Attribute1,Attribute3  (Formatted)   (blank)    (Formatted), etc...
Product2  Attribute2,Attribute3    (blank)   (Formatted)  (Formatted), etc...

So, if the column name appears in the respective row's csv, then format the cell.

Is this possible?

Upvotes: 2

Views: 2258

Answers (1)

Robin Gertenbach
Robin Gertenbach

Reputation: 10776

Make the conditional formatting by formula, set the range (in this case) to $C$2:$E$3 and the formula to =SEARCH(C$1, $B2) The relative reference will do the rest by adjusting the search term and lookup range automatically

Upvotes: 3

Related Questions