SOLVED

[QUERY] How to Highlight Cells of the Same Colour : Microsoft Excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1584384%22%20slang%3D%22en-US%22%3E%5BQUERY%5D%20How%20to%20Highlight%20Cells%20of%20the%20Same%20Colour%20%3A%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1584384%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThis%20was%20my%20Google%20search%2C%20no%20relevant%20results.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%22microsoft%20excel%20how%20to%20highlight%20cells%20of%20the%20same%20colour%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20highlight%20all%20the%20cell%20of%20the%20same%20colour%2C%20so%20that%20I%20can%20change%20them%20all%20at%20once.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EE.g.%20Highlight%20all%20the%20blue%20cells%2C%20so%20that%20I%20can%20change%20them%20to%20red.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20some%20way%20to%20do%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EConditional%20formatting%20only%20looks%20at%20Cell%20Values%20like%20Text%2C%20Errors%2C%20Blanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1584384%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1584449%22%20slang%3D%22en-US%22%3ERE%3A%20%5BQUERY%5D%20How%20to%20Highlight%20Cells%20of%20the%20Same%20Colour%20%3A%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1584449%22%20slang%3D%22en-US%22%3ESave%20the%20file%20first.%20Select%20the%20entire%20range%20you%20want%20to%20change%20that%20contain%20the%20colored%20cells.%20On%20the%20home%20tab%20of%20the%20ribbon%20go%20to%20Find%20and%20Select%20on%20the%20far%20right%2C%20and%20select%20Replace....%20Click%20on%20the%20OPTIONS%26lt%3B%26lt%3B%26lt%3B%20box%20to%20display%20the%20other%20options.%20On%20the%20Find%20what%3A%20line%20choose%20Format...%20Choose%20Format%20from%20the%20list.%20Find%20the%20Fill%20tab%20and%20select%20the%20current%20color.%20Say%20OK.%20Do%20the%20same%20thing%20for%20the%20Replace%20with%3A%20line%20and%20choose%20the%20new%20color.%20Click%20Replace%20All.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1591466%22%20slang%3D%22en-US%22%3ERE%3A%20%5BQUERY%5D%20How%20to%20Highlight%20Cells%20of%20the%20Same%20Colour%20%3A%20Microsoft%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1591466%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F628423%22%20target%3D%22_blank%22%3E%40SqueakySneakers%3C%2FA%3E%3C%2FP%3E%3CP%3EThanks%20that%20worked.%3C%2FP%3E%3CP%3ECtrl-H%2C%20expand%20Options%2C%20Format%2C%20Choose%20Colour%2C%20Fill%20Tab%2C%20Choose%20colour%20and%20replace.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

 

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 all at once.

 

E.g. Highlight all the blue cells, so that I can change them to red.

 

Is there some way to do this?

 

Conditional formatting only looks at Cell Values like Text, Errors, Blanks.

2 Replies
best response confirmed by yeokaiwei (New Contributor)
Solution
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.

@SqueakySneakers

Thanks that worked.

Ctrl-H, expand Options, Format, Choose Colour, Fill Tab, Choose colour and replace.