How to highlight a partner when a value is reached
I was wondering if anyone has an idea how to highlight a cell when a partners reward value exceeds a Dollar amount?
I currently have a sheet that is updated from an external source on a fortnightly basis that shows clients invoice values. From this data I have a formula that calculates a reward amount on the same sheet to the right using some basic formulas.
From this I have a report that shows the partners name and the reward amount, but it wont let me "sort" by the reward value descending as its grouped by reseller name.
One option I have explored was to have a second sheet to "summaries" the reseller name and rewards value and create a sort of Pivot table but haven't been able to get this to work as the source data change.
Help Article Resources
Check out the Formula Handbook template!