Limit the number of characters in a cell + color Excel
Solved
dezie
-
dezie -
dezie -
Hello,
Can you help me please???????????,
I'll explain:
I need to highlight in red the cells that exceed 38 characters in an Excel database.
Knowing that with "conditional formatting" I can't limit the number of characters, the same goes for the IF function, and with "data/validation..." I can't insert a color
Thank you for your urgent help!!!
Can you help me please???????????,
I'll explain:
I need to highlight in red the cells that exceed 38 characters in an Excel database.
Knowing that with "conditional formatting" I can't limit the number of characters, the same goes for the IF function, and with "data/validation..." I can't insert a color
Thank you for your urgent help!!!
Configuration: Windows Vista Internet Explorer 7.0
2 réponses
Good evening
In principle, with conditional formatting, you do not need the IF function:
It will suffice to choose the "formula" option in the formatting and place the formula you are interested in, in this case for cell A1
=LEN(A1)>38
Choose your format, close with OK
Note that with the data/menu/validation, you can not change the color, but display a warning message when the text is too long:
Data / Validation / Text Length / Min 0 / Max 38
Click on the error alert tab and choose instead of stop: information or warning message.
Enter the title (for example, WARNING) and the text (for example "text too long")
And close with OK
BCRDLMNT
--
The truth is not possessed, it is only sought.
In principle, with conditional formatting, you do not need the IF function:
It will suffice to choose the "formula" option in the formatting and place the formula you are interested in, in this case for cell A1
=LEN(A1)>38
Choose your format, close with OK
Note that with the data/menu/validation, you can not change the color, but display a warning message when the text is too long:
Data / Validation / Text Length / Min 0 / Max 38
Click on the error alert tab and choose instead of stop: information or warning message.
Enter the title (for example, WARNING) and the text (for example "text too long")
And close with OK
BCRDLMNT
--
The truth is not possessed, it is only sought.
I’ll keep you updated!!
Thank youuuuuuuuuuuuuuu!
it's exactly what I wanted!!
thank you again for your help!