Conditional Formatting Based on Number of Characters

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.

Best Answer

  • Genevieve P.
    Genevieve P. Employee Admin
    Answer ✓

    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

Answers