Change text colour when crossing character limit

**vivekhalder** · 02-14-2010, 09:56 AM

Hi,

In a cell when I type a word more than 22 characters the text should turn red.

I used data validation for character limit but not able to construct any formula to turn the text red when it crosses the limit.Don't want any error warning as given by data validation.

I also tried with conditional formatting but no success.

PLEASE HELP !!!!

Sorry if its a repost.

Thanks in advance

Vivek

**martindwilson** · 02-14-2010, 10:10 AM

you can use the use a formula option in conditional formatting then put
=LEN(A1)>22 however it will not change while you are typing only after you exit the cell