Forum Discussion
Solved
[QUERY] How to Highlight Cells of the Same Colour : Microsoft Excel
This was my Google search, no relevant results. "microsoft excel how to highlight cells of the same colour" I want to highlight all the cell of the same colour, so that I can change them a...
- Save the file first. Select the entire range you want to change that contain the colored cells. On the home tab of the ribbon go to Find and Select on the far right, and select Replace.... Click on the OPTIONS<<< box to display the other options. On the Find what: line choose Format... Choose Format from the list. Find the Fill tab and select the current color. Say OK. Do the same thing for the Replace with: line and choose the new color. Click Replace All.
Save the file first. Select the entire range you want to change that contain the colored cells. On the home tab of the ribbon go to Find and Select on the far right, and select Replace.... Click on the OPTIONS<<< box to display the other options. On the Find what: line choose Format... Choose Format from the list. Find the Fill tab and select the current color. Say OK. Do the same thing for the Replace with: line and choose the new color. Click Replace All.
Thanks that worked.
Ctrl-H, expand Options, Format, Choose Colour, Fill Tab, Choose colour and replace.