Engineers-Excel.com

Find and Replace Colours



Recently one of my friends was showing me how he was redesigining an image where he was replacing some colours with different ones. I showed him how similar work can be done in Excel. In this Tip, we will see how to find and replace cell colours using a macro. A sample file with the macro can be downloaded here.

The file contains coloured cells, we want to change the colour of the green cells to yellow. To do this, select the image and click on the button. The button runs a macro that loops through the selected range and replaces the colours accordingly. The following pictures show the cells before and after the macro is run.

Before the change:

Before Change

After the Change:

After Change