PDA

View Full Version : Find and format only specific text/numbers



Jordie..
08-28-2018, 12:34 AM
Hi all,


I'm working with an application that gives results back in excel files. However there's quite alot of information in these files.


The below link already helped me along the way solving the problem I've run into:
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other-mso_archive/find-and-format-only-specific-text-in-cell/bdaf116b-5583-4501-95c0-b36b340c941d
Like you can see in this link, I'd like to change only certain words in the whole worksheet. However, I'd like some more adjustments.


I'd like to change EACH number in just one certain column to another color (while leaving the rest of the text untouched). In the same column (sometimes the same cell) there could be a certain string containing both text and numbers. These strings have to get another color then the other numbers. Another font needs to be corrected for codes beginning with hashtags.


Example of that column:
Status:3, Code:99385DNF8300DC3, Part:9374, Location:#7264


Thanks in advance,
Jordie