Google SpreadSheet conditional formatting based on number of characters

Question

In Google Spreadsheet, is there a way to conditionally format a cell if it has more than 30 characters?

Answer 1

Not on the cell itself, without the usage of Google Apps Script. Adding a helper column will allow you get realy close:

A1 and A4 both have more than 30 characters. Set the whole column to have a conditional format like this:

Now add the following formula in B1:

=ARRAYFORMULA(LEN(FILTER(A:A;A:A<>""))>30)

This will check column A, whether the entry has more than 30 characters and will return TRUE or FALSE.

See example file I've prepared: more than 30 characters