Condiitional Format

[Tim]

I have a grid similar to this where the first column is a label and the other columns are years.

            2020    2021

Apps    2,000   3,000

Orgs     3,000   7,000

Total    5,000   10,000

% Chg               50%

I would like for the numbers to be formatted as they are above. That is, in all of the rows except the last one numbers are formatted with comma separators, and in the last row numbers are formatted with a trailing %.

Is there a way to conditionally format the numbers depending on the row?

Thanks,

Tim

[Tim]

I was able to solve this with a conditional in a ClientTemplate.