Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Conditional formatting based on character count
4,443 views
Skip to first unread message
H.@discussions.microsoft.com Rhonda H.
Sep 2, 2009, 7:17:01 PM9/2/09
to
I need to conditionally format the cell to be highlighted if the total
character count (=len) of the cell is greater than 50. I am close. I can do
it in multiple steps. I would like to combine it in a single formula if
possible. Can anyone help?
character count (=len) of the cell is greater than 50. I am close. I can do
it in multiple steps. I would like to combine it in a single formula if
possible. Can anyone help?
Pete_UK
Sep 2, 2009, 7:25:07 PM9/2/09
to
Select the cell(s) that you want this to apply to (suppose A1 is the
active cell if you have more than one highlighted), then in the
Conditional Format dialogue you need to select Formula Is rather than
Cell Value Is in the first box, and enter this formula:
active cell if you have more than one highlighted), then in the
Conditional Format dialogue you need to select Formula Is rather than
Cell Value Is in the first box, and enter this formula:
=LEN(A1)>50
Then click on the Format button, choose the Patterns tab (for
background colour) then click on the colour you want to show. Click OK
twice to exit the dialogue box.
Hope this helps.
Pete
On Sep 3, 12:17 am, Rhonda H. <Rhonda H...@discussions.microsoft.com>
wrote:
0 new messages