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?
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?