I would like to highlight Table entries that have large percentage changes from the entry in the previous column.
In the example below, Jet Skis and Wet Suits have large percentage drops in Q4 from the Q3 value.
Is there a Formula syntax for the Table formatting that would evaluate the change from the Q3 column to Q4, in order to determine whether the Q4 value should be highlighted?
Thanks for any help!
| | Q1 | Q2 | Q3 | Q4 |
| Jet Skis | 30 | 31 | 32 | 25 |
| Pool Noodles | 10 | 10 | 11 | 12 |
| Chlorine | 12 | 12 | 13 | 13 |
| Scuba Snorkels | 6 | 5 | 5 | 5 |
| Scuba Fins | 5 | 6 | 7 | 8 |
| Knives & Weights | 3 | 3 | 3 | 3 |
| Regulators | 9 | 9 | 10 | 9 |
| Wet Suits | 40 | 41 | 39 | 30 |
| Air Tanks | 25 | 26 | 25 | 24 |