Color cells that have a prefix beginning with...

Hi,

I have an existing script that looks through a selected range and asks the user to state which prefix's to color yellow, The script works great, however, I would like it to color only cells that have a cell value length greater than 3. Any help would be greatly appreciated

Please Login or Register  to view this content.

Originally Posted by sriley5

Hi,
I would like it to color only cells that have a cell value length greater than 3. Any help would be greatly appreciated

Please Login or Register  to view this content.

Originally Posted by jindon

Please Login or Register  to view this content.

Thanks, that worked like a charm, here is the amendment to my existing code

Please Login or Register  to view this content.