Thursday, 9 May 2013

0% - 100%

Did some conditional formatting on a Google Spreadsheet today and needed to colour code grades between 0 and 100% so borrowed this from Path to SharePoint for future reference.

10% - #ff3300
20% - #ff6600
30% - #ff9900
40% - #ffcc00
50% - #ffff00
60% - #ccff00
70% - #99ff00
80% - #66ff00
90% - #33ff00
100% - #00ff00