I have a spreadsheet where certain (multiple) cells have length guidelines for character length within them.
I have been scouring the web to find some VBA to highlight the text that exceeds the specified length guideline.
Max Characters = 25
Cell text = The quick brown fox jumped over the lazy dog.
However, I would like to HIGHLIGHT the text (like a yellow highlighter) with no other change to the formatting.
Since there are multiple fields in this sheet with different character guidelines I figured approaching it from a function perspective would be my best bet. I could then call the function (sub) with the cell and character number as variables.
Here's what I have which doesn't really seem to work at all (and tries to bold the text instead of highlighting).
I think it is because I'm not using the right syntax to identify the cell in the sub call but it should illustrate what i'm trying to do.