Limit to conditional formatting appears to be 10 per column. Any work around except creating another column next to it for those additional rules or functions, then copy/paste data from one column to next?

Conditional formatting limits

1 Answer 1


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:

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.