How to highlight a partner when a value is reached

Daniel Stuckey

Hi Team,

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.

Any thoughts?

Daniel

hollyconradsmith

Hi @Daniel Stuckey,

You could use conditional formatting to highlight the cell visually. The conditional formatting you set on the source sheet will carry over to the report.

https://help.smartsheet.com/learning-track/level-1-get-started/conditional-formatting