VBA code to change font colour of cell referenced letter strings within a range of cells

[Klofange]

I am working on a spreadsheet for work, and have managed to do everything I need to so far but I need to colour specific letter strings, certain colours within a range of cells (each letter string will only appear once on each sheet)

The strings I will be looking for vary depending on data entered so I will need to cell reference them

The strings that need colouring are in cells with other strings that must stay black (They cannot be separated from other strings due to the nature of the grid)

I need some strings red, some green, and some blue.

These changes should also apply to the whole workbook not just one sheet.

Is there a way to do this with the VBA code.

I hope that makes sense. Unfortunately I am not allowed to post the workbook I am working on online just to my workplaces Intellectual property policy.

Thank you very much

[protonLeah]

color some words

Please Login or Register  to view this content.

[Klofange]

Hi there, thank you for your response, I am having a problem getting it to work (and I can't open your file, it seems to be a shortcut)

So if the word that need searching for are in cells BH2:BH32 (green), BI2:BI32 (blue), BJ2:BJ2 (red)

and the range of cells I want the colours to change in is C6:AK22

how would I vary the VBA you gave me?

Cheers again

Harrison

[protonLeah]

Please Login or Register  to view this content.