Text count
Closed
shujay
-
Oct 5, 2010 at 02:31 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 5, 2010 at 06:27 AM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Oct 5, 2010 at 06:27 AM
Related:
- Text count
- How to count names in excel - Guide
- Count occurrences in excel - Guide
- Do chats count towards best friends on snapchat 2023 - Guide
- Hide view count youtube - Guide
- Count in french excel - Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Oct 5, 2010 at 06:27 AM
Oct 5, 2010 at 06:27 AM
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.
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.
