Conditional Formatting Based on Number of Characters

Ben B.

Is it possible to apply Conditional Formatting to a cell based on the number of characters in the cell? I can think of how to do it using a helper column, but I'm curious if there's a way without adding an additional column.

Genevieve P.

Hey @Ben B.

Conditional Formatting does not currently have way of evaluating a cell to see how many characters are in it; I would also suggest using a helper column with a LEN formula to count the characters, then base the formatting off of that column instead.

Cheers,

Genevieve

Genevieve P.

Hey @Ben B.

Conditional Formatting does not currently have way of evaluating a cell to see how many characters are in it; I would also suggest using a helper column with a LEN formula to count the characters, then base the formatting off of that column instead.

Cheers,

Genevieve

Ben B.

@Genevieve P. Thanks! I ended up using helper columns and the LEN function.