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 |
No comments:
Post a Comment