Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In an earlier post:
http://groups.google.co.in/group/mic...ae9e72ad?hl=en I had sought help in extracting words containing capital letters and/ or numbers from cells in Column C to corresponding cells in Column D. eg. Column C2 has the sentence "The TKRTC value in the 765TW field is not the default.". I wanted Column D2 to have "TKRTC 765TW". Ron Rosenfeld and Rick Rothstein had contributed with Regexp and non- Regexp solutions on that occasion. Now, instead of Column D, I would like cells in Column C containing such words be filled with a certain color and the word(s) be displayed in bold. I would love to see both Regexp and non-Regexp versions of the vba code for this. Thanks in advance for all the help. Raj |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I highlight a single word or group of words? | Excel Discussion (Misc queries) | |||
Can I highlight misspelt words in cells when I use the spell check | Excel Discussion (Misc queries) | |||
how to change all the words of one type(Gunsuh type)to another | Excel Discussion (Misc queries) | |||
Why does / key act like Alt+F and highlight file menu not type / | Excel Worksheet Functions | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) |