Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I have a pivot table with some numerical values and I need some formula in order to highlight them either green or red. What I need to do is to calculate if the numbers in the rows under the first one (the first row stays in place and it's always green) are either +- 5% of the number in the first row that's above it. How do I do this?
Thanks,
Adrian
PS: I have the free version, so I'm not able to open any file.
Hi,
If I'm using Top(expression) it doesn't take into account any number after the second one. Basically, if the first number in the column is 100, the second one is 95, let's say, 95 will be green, which is good, but the rest of number will be red, regardless of their value..
Adrian
Hi, Check attachment, in simple example it works, maybe your table has more dimensions and need to use a TOTAL or something, can you post a sample?
Or you can use directly Top(expression) to check what value is used to compare, it will give you a hint of how to solve.
Unfortunately, I cannot open attachments for I have the free version
What formulas did you use?
The same formula, but it works in a simple example:
If (Value<Top(Value)*1.05 and Value>Top(Value)*0.95, green(), red())