software

I want to format a cell so that if someone puts more then 15 characters in
the cell the cell will turn red. Any help would be appreciated.

=LEN(A1)gt;15

format gt; conditional formatting, formula is

you could also use data validationgt; allowgt; text length less than or equal to
15

that way they cannot enter anything longer as long as they type--

Regards,

Peo Sjoblom

nwexcelsolutions.comquot;Rich Stanekquot; gt; wrote in message
...
gt;I want to format a cell so that if someone puts more then 15 characters in
gt; the cell the cell will turn red. Any help would be appreciated.
You need conditional formatting.

Select the cell (let assume D4), then from the menu, select Format, then
Conditional formatting. In the conditional formatting dialogbox, select
quot;formula isquot; from the dropdown box and type =LEN($D$4)gt;15 in the textbox.
This applies the condition. Now you need to select the formatting that will
be applied whenever the condition is true. Click on the format button on the
conditional formatting dialogbox then go to the pattern tab and select red.

Now whenever the length of text entered into D4 is more than 15, the cell
colour will change to red.

Delordson Kallon
www.instantsoftwaretraining.com/Default.aspx

quot;Rich Stanekquot; wrote:

gt; I want to format a cell so that if someone puts more then 15 characters in
gt; the cell the cell will turn red. Any help would be appreciated.