Highlight cells with more than 40 characters
Solved
kalystha
Posted messages
339
Status
Member
-
Excel-worker Posted messages 603 Status Member -
Excel-worker Posted messages 603 Status Member -
Hello everyone,
I need to modify a very large number of files, with one condition,
that in certain columns, I must not exceed 40 characters.
How can I highlight the relevant cells?
I've tried using conditional formatting, but I couldn't find anything.
Thank you for your help.
Best regards.
I need to modify a very large number of files, with one condition,
that in certain columns, I must not exceed 40 characters.
How can I highlight the relevant cells?
I've tried using conditional formatting, but I couldn't find anything.
Thank you for your help.
Best regards.
2 answers
Hello,
In the same way as the MFC, you can place this formula in a column:
=IF(LEN(H10)>40,"alert","character respected"), then go to the column where you placed the formula and apply an alert filter. You will be able to see everyone who has exceeded 40 characters.
For better usability, you can hide the column and then unhide it for verification.
Best regards
In the same way as the MFC, you can place this formula in a column:
=IF(LEN(H10)>40,"alert","character respected"), then go to the column where you placed the formula and apply an alert filter. You will be able to see everyone who has exceeded 40 characters.
For better usability, you can hide the column and then unhide it for verification.
Best regards
thank you for your quick response, but I must have forgotten a step, it's not working. I select my column, MFC LEN(first cell of my column) > 40 with my character color formatting, etc. .. Nothing is happening.