Conditional formatting based on formula Excel

Question

I am trying to create a rule for conditional formatting that highlights the column yellow if the header of the table contains the same value as is contained in cell A1, but it says my formula has an error. Does anyone have any ideas?

Here is my formula:

 =CELL("col", INDIRECT(ADDRESS(ROW(), COLUMN()))) = (MATCH($A$1,Table1[#Headers],0)+2)

EDIT: The formula works when I put it into a cell, just not when I put it into the 'new rule' section of conditional formatting.

nbayly · Accepted Answer · 2016-09-12 21:43:20Z

1

Create a conditional rule applying to the relevant column (say G with header in $G$1) with the following rule:

=AND(G1<>"",$A$1=$G$1)

I don't think you can reference the header with the Table Structured reference that you used which is why I hardcoded the range. Regards,

answered Sep 12, 2016 at 21:43

nbayly

2,1672 gold badges16 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

reggie86 Over a year ago

You're right-- it was the table reference-- thanks a million!

Collectives™ on Stack Overflow

Conditional formatting based on formula Excel

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related