You can use Google App scripts to write your own set of rules since the default is limited to 10 per column. The below links should help:

https://support.google.com/drive/answer/78413?hl=en http://igoogledrive.blogspot.in/2012/08/how-to-condition-cell-so-that-if-value.html

You can use Google App scripts to write your own set of rules since the default is limited to 10 per column. The below links should help:

• Google Help: Apply conditional formatting rules
• How to condition a cell, so that if the value of a cell is higher than a certain number, it will automatically show a certain number or else show that value.