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)15

format conditional formatting, formula is

you could also use data validation allow text length less than or equal to
15

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


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com


"Rich Stanek" wrote in message
...
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.

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
"formula is" from the dropdown box and type =LEN($D$4)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
http://www.instantsoftwaretraining.com/Default.aspx

"Rich Stanek" wrote:

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.