How to use Row label and Column label in Pivot conditional formula

[RohanSatha]

Hey All,
I have a pivot table with two different date fields in row_label & column_label. I need to do conditional formatting on value cells using row label & column label header as values in formula. I need to know how to refer these two(header) in formula. thanks

Example: = column label > row label

Have attached it for better understanding..

 

[Luke M]

As the column labels will always be in same row, and row labels will be in same column, you should be able to do something like:
=B$3>$A5

If that won't work, perhaps you could give some more detail as to what the layout of the PT is, and/or what you are trying to highlight?

 

[RohanSatha]

Hey Luke,

Thanks a lot for your concern. I have attached a sample file with the situation in my previous thread.

Regards,
Rohan.S

 

[RohanSatha]

Hey Luke,

As you mentioned, freezing label method is working perfectly. It's really helpful. Thank you

Regards,
Rohan.S