Hello everyone,
My question is regarding using tables as named range in conditional formatting. It is the only way I have had success with it.
What I was wondering is there a way to keep some of the functionality for xlookup by the column header in the named range, or must I create a new name for each column?
My question is regarding using tables as named range in conditional formatting. It is the only way I have had success with it.
What I was wondering is there a way to keep some of the functionality for xlookup by the column header in the named range, or must I create a new name for each column?