Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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

share|improve this question
add comment

2 Answers 2

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

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

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

share|improve this answer
add comment

If your cell is A1, in New Google Sheets, in Custom formula is please try:

=len(A1)>30 withRange: `A1` and the formatting of your choice.
share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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