Looking for help in creating a macro that will count the length of each cell in column "F", and if any cell is over 24 characters in length, color the cell green. Thanks in advance for any help
Looking for help in creating a macro that will count the length of each cell in column "F", and if any cell is over 24 characters in length, color the cell green. Thanks in advance for any help
Last edited by mshirley15; 11-09-2012 at 03:53 PM.
Try
Please Login or Register to view this content.
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
Maybe this onePlease Login or Register to view this content.
"=LENGTE(F1)>24"
has to be (for the english version).
"=LEN(F1)>24"
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Works perfect WasWodge, thanks for your help.
p.s. love the your avatar
Your welcome but you should also consider the code from oeldere (shorter version below) as because it uses conditional formatting it will change as you change each cell (depends what you need it for) and it doesn't loop.
Obviously you can change the range to Columns("F:F").Select if you wish, I just prefer not to select whole columnsPlease Login or Register to view this content.
Last edited by WasWodge; 11-09-2012 at 04:27 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks