How to highlight a cell that contains more than 50 characters using conditional formatting?

[rajtak]

How to highlight a cell that contains more than 50 characters using conditional formatting?

Please let me know your suggestions.

Thank you in advance.

 

[Robert Mika]

=len(a1)>50

 

[rajtak]

Hi Robert,

Thank you but this is not working in conditional formatting

 

[brettdj]

The formula will work

When you apply it
- select your range from the top left cell and move down and accross as need
- use a new rule based on a formula
- use = LEN(A1)>50 where A1 is the same cell address as your top left cell in the range to be formatted (ie it may be C1, A28 etc in your actual example)

Cheers
Dave