Quote Originally Posted by Nikko77 View Post
"This worked like a dream! I am very rusty with VBA though, can someone please tell me how to ask it to perform multiple actions. I forget which part of the code I need to copy for it to repeat.

I would like it to find the following and shade the cell that colour:
The solution discussed extensively in this thread requires no VBA.