Hi Peter and Bernie,
thank you! I posted a reply to Bernie 5 or 6 hours ago, so hopefully
it will post soon. It has my dream code a little better articulated.

As soon as I get to work tomorrow, I will try out Peter's code. I feel
much closer to getting it working, though.

Peter, in this line of code:

If c.Offset(0, -1) = ":"

How would I check to see if any part of the cell contained a colon?
That is, not equal to ":" but contained ":"? For example, "nice:guys"
and "thank:you" would also pass the test and continue on to the "then"
statement?

I am so excited! Thanks again,
Jennifer.