Forum Discussion
Solved
Color Shading in the Cell based on Column Percentage Value in a List
Hi all,
I've searched through the postings and cannot find what I'm trying to accomplish. (see attachment - I worked up a sample)
I would like a color code in the column field to change based on the percentage complete.
0-25% = Red
26-50% = Orange
51-99% = Yellow
100% = Green
Notes: There are 3 columns that calculate the percentage. Total subtracting Done = Remaining.
EX: Total items = 9, 6 are Done with 3 remaining = 67% complete.
Any ideas on how to make this happen? Many thanks in advance.
SharePoint 365
Hello SheTriedIt,
JSON column formatting will help format your column as required. Specifically, see risk-score.json in https://github.com/SharePoint/sp-dev-list-formatting/tree/master/column-samples/generic-project-management.
If you need help on creating the calculate columns see Examples of common formulas in SharePoint Lists.
I hope this helps.
Norm
Edit: Added example with code.
1 Reply
Hello SheTriedIt,
JSON column formatting will help format your column as required. Specifically, see risk-score.json in https://github.com/SharePoint/sp-dev-list-formatting/tree/master/column-samples/generic-project-management.
If you need help on creating the calculate columns see Examples of common formulas in SharePoint Lists.
I hope this helps.
Norm
Edit: Added example with code.