Text count
Closed
shujay
-
5 Oct 2010 à 02:31
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 5 Oct 2010 à 06:27
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 5 Oct 2010 à 06:27
Related:
- Text count
- Excel count occurrences - Guide
- How to hide subscriber count - Guide
- Count names in excel - Guide
- Mysql count occurrences of value in column - Programming Forum
- How to count sentences ✓ - Programming Forum
1 response
venkat1926
Posts
1863
Registration date
Sunday 14 June 2009
Status
Contributor
Last seen
7 August 2021
811
5 Oct 2010 à 06:27
5 Oct 2010 à 06:27
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.
