Hello everyone

After spending some time developing a series of models for various business users, one of my colleagues has now advised me that the RGB index I've been using in every model is in fact slightly different to what it should be (our marketing is very strict on the exact colours we use).

I'm trying to code a solution to this in VBA but failing. So the question is, I need a sub that will loop through every cell on every worksheet in a given workbook, and if the cell interior colour matches the RGB index in question, it changes the interior colour to a different RGB index.

If anyone can show me how to do this I will be incredibly grateful

Many thanks
Bonnister