highlight whole column if header contains specific text

[BORUCH]

I have an aging table in excel

I have customer #| customer name| invoice #| invoice date| invoice amount| over 30| over 45| over 60| over 90|

I would like to conditionally format all the over 90 values.

The problem is if i filter the table the over 90 column can be in a different column (depending on what the customer owes)

How do I go about it that it should find the header over 90 and highlight all values underneath it?

 

[63falcondude]

I answered you here

http://www.mrexcel.com/forum/excel-...eader-contains-specific-text.html#post4609129

 

[BORUCH]

I answered you here

http://www.mrexcel.com/forum/excel-...eader-contains-specific-text.html#post4609129

for some reason when I slice my data in a pivot table the “applies to” in conditionally formatting gets changed is there a way around that