In pivot table, we have four column limit1, limit2 , actual value and limit%

[nishika]

We have to highlight the Row value of Limit1 or Limit2  based on which limit value  we are using for calculating Limit %.

Limit % calculation based on below condition:

If todays date > expiry date , actualvalue /Limit 1,actual value/ Limit2

So if we are using Limit1 or Limit2 for calculating limit % value that value needs to be highlighted.

[morgankejerhag]

Hi,
I don't understand you question. Can you explain how your data looks like and explain more about when you want to highlight. Is "actualvalue" the same as "actual value"? Is "Limit 1" and "Limit 2" two data fields?