Hello Pros,
I've been searching long and hard how to do this simple task, yet, I can't figure it out. Search days on the web or trial and error, I still can't find a simple solution.

I wish to do a Search for a "Word / Symbole / Values / Texts", in a Table, with many rows and a couple of Columns. I get those very often.

I have already created a macro to ID texts or values, by: Highlight them + put Fonts in Bold + in Color (some are in Red, others in Green).

Now to be certain, I don't miss a cell with those values, if I scroll too quickly, I do miss one or more, I wish to have those Cells with the Highlighted, Bold, and Color "Word / Symbole / Values / Texts", with a background Shade of this color, if possible = (.Shading.BackgroundPatternColor = -654246093). It's supposed to be a paler shade of Orange (very very light), so not agressif as a color, but enough to get my attention.

***By the way, it can have more than one of the same value in the cell, It doesn't matter, as soon as it finds one of those value, have the whole cell in the color of shade that I gave the decimal value.

Any insights?

I could show you my many fail attemps of my macros, but I think I would confused people. May as well get a guidance how to accomplish this task.

Unless it's not doable?

Many thanks in advance, I am soooooooooooooo appreciative in advance for your help

Happy New Year pro's.



Cendrinne