Text count

Closed
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello,

I want in excel conditional format when text have more than 5 character,then change the colour.

please help.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
suppose the texts are entered in column A.
goto A1 -click format-conditional format
under "condition 1"
choose "the formula is"
in the right hand side window type
=len(a1)>5
click "format" in the second row of the "conditional formatting " window
in the format cells window that comes up choose
"pattern" the last item in the top row
color pallette will come up
choose a color (e.g. yellow)
click ol format cell window
click ok in "conditional formatting" window

now select A1 and click edit-copy
select A2 down as many as you require (e.g. upto A10)
click edit-pastespecial-formats and click ok

now type any text less then or equal to 5 characters in the range A1 to A10 what happens. nothing will happen
in the same cell or another cell type a text more than 5 characters. the cell will turn into the yellow.

you can use this technique even if your data is not column A.