Conditional formatting by number of characters in cell

[drfrot]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Hi,

Struggling to work out how to do this and would value help.

I'm entering text into a cell and I simply want the colour of that text to change to red when I exceed 255 characters.

How do I do this? Using "Cell Value Is", or "Formula Is"?

Thanks

Giles

 

[drfrot]

> I'm entering text into a cell and I simply want the colour of that text to change to red when I exceed 255 characters.
>
> How do I do this? Using "Cell Value Is", or "Formula Is"?
>

After a lot of trial and error... to answer my own question, it should be conditioned as "Formula Is", with the formula:
=LEN(A1)>255

Job done!

:¬)

 

[John_McGhie_[MVP]]

Well done! You had me thinking there for a minute

After a lot of trial and error... to answer my own question, it should be
conditioned as "Formula Is", with the formula:
=LEN(A1)>255

Job done!

:¬)

--

The email below is my business email -- Please do not email me about forum
matters unless I ask you to; or unless you intend to pay!

John McGhie, Microsoft MVP (Word, Mac Word), Consultant Technical Writer,
McGhie Information Engineering Pty Ltd
Sydney, Australia. | Ph: +61 (0)4 1209 1410 | mailto:[email protected]