Search cell with specify ColorIndex

Range SearchRng is a predefined range that I have!

If I want to search SearchRng for text "Test" then I would use this code

Please Login or Register  to view this content.

However, instead of "Test", I want to find Cell with Interior.ColorIndex = 4

Would you help please!?

Thank you,

NTB

Hi NTB, if you want to find a cell with a particular interior colour, than I would go with something like

Please Login or Register  to view this content.

You will have to substitute the range I used with yours and then add what you want to do to the cells once you find them though. Let me know if this helps.