Highlight leading and trailing spaces of text within cells

I need a macro that will highlight (in yellow) the spaces within a cell that lead or trail a string of text. The spaces between the words or values should not be highlighted. Also, I am not wanting to color the entire cell. I would like to run the macro for all cells in a worksheet.

Any thoughts?

Interesting - you cannot highlight a space...

As there is no 'text' (so to speak) in a space character, you cannot highlight a leading or trailing space and change the font colour. You also cannot use a fill, or background, colour as that applies to the whole cell only.

Your best bet is Conditional Formatting but that can only work on a cell basis.