If you notice from the below results, certain cells did not receive the updated light green color even though they possessed the appropriate light blue fill color.
The reason is that when we clicked on a cell to define the current cell color, we also (unknowingly) defined the font size, font color, font style, cell alignment, border, bold, italic, underline attributes, etc…
In other words, all visual aspects of the cell.
The cells that are not bold failed to receive the light green fill color because the Replace operation was only looking for cells that possess bolded text.
In order to select cells based on their fill color and not any of the other cell’s visual attributes, we need to search for the color only.
An easy way to determine the original search color is to select an existing cell with the light blue fill color and select the down arrow next to the “Fill Color” button and select “More Colors…”.
In the Colors dialog box, select the “Custom” tab and record the values located in the “Red”, “Green”, and “Blue” fields.
Cancel the dialog box and return to the “Replace” dialog box (CTRL-H).
Because the Replace feature retains the previous selections, we need to clear the format options from the “Find what” option. Using the “Find what” option, click the small down arrow to the right of the “Format” option and select “Clear Find Format”.
Click the small down arrow to the right of the “Format” option and select “Format”.
Select the Fill tab and then click the “More Colors” button to access the fill color pallet.
On the “Custom” tab, enter the same “Red”, “Green”, “Blue” code number recorded from the earlier step.
Because we wish to perform this modification on all sheets in the workbook, change the “Within” option to “Workbook” and click “Replace All”.
Every cell on every sheet in the workbook that possessed the original light blue fill color has been updated with the new light green fill color color.