First of all, let me take the chance to thank each one of your for reading my post and assisting me with my dilemma.
I require assistance with a conditional formatting formula.
I want to parse each word or segment in my spreadsheet so that only vowels and semivowels (a, e, i, o, u, y, and w) are made bold.
For example, if my spreadsheet contains these words, I want them to show up in the spreadsheet automatically as such:
- star → st(a)r
- hap-py → h(a)p-p(y)
- birth-day → b(i)rth d(ay)
- wel-come → w(e)l-c(o)m(e)
- in-for-ma-tion → (i)n-f(o)r-m(a)-t(io)n
If someone could please assist me with this, I would be more than grateful.