Excel cells coloring

[Maxlond]

Hey,
I have a request how to change my macro so that not only cells with the word "Cash" are colored, but all cells containing "Cash" in the text

Please Login or Register  to view this content.

[alansidman]

Replace this line

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

[mehmetcik]

Hi Max

If you have a lot of data your macro will be slow

This will color all your errors orange without a loop

Please Login or Register  to view this content.

This code will also color all cells with Cash Green

Please Login or Register  to view this content.

[TMS]

Try (untested):

Please Login or Register  to view this content.

[TMS]

Why use a macro, why not use Conditional Formatting?