And then click to choose one cell which contains the color that you want to replace, after selecting the cell color, then click Format besides the Replace with section, and choose Format from its drop down list, see screenshot:ĥ. Then click Options > button to expand the Find and Replace dialog box, in the expanded dialog box, click Format besides the Find what section, and select Choose Format From Cell from the drop down list see screenshot:Ĥ. Press Ctrl + H to open the Find and Replace dialog box, see screenshot:ģ. Select the range cells that you want to find and replace the fill color.Ģ. To find the same fill color cells and replace them with another color you like, the Find and Replace feature in Excel may help you to finish this job.
In Excel, you may fill different background colors to make the important value outstanding, but, have you ever tried to find the cells contain same color and replace them with another color at once in Excel?įind and replace fill color with Find and Replace featureįind and replace fill color with Kutools for Excel Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.How to find and replace fill color in Excel? Execute FindText:="", ReplaceWith:="", _ The selection remains unchanged because the Find object is accessed from a Range object (the Content property returns a Range object). To find and replace formatting, set the find and replace text to empty strings ("") and set the Format argument of the Execute method to True. The Bold property is True for the Find object and False for the Replacement object. The following example removes bold formatting in the active document. Execute Replace:=wdReplaceAll, Forward:=True, _ The selection changes when the find criteria is found because the Find object is accessed from the Selection object. The following example replaces all occurrences of the word "hi" with "hello". The Replacement object is available from the Find object. The properties and methods of the Replacement object correspond to the options in the Find and Replace dialog box ( Edit menu). The Replacement object represents the replace criteria for a find and replace operation. The following example performs the same result as the previous example, using arguments of the Execute method.
If the find operation is successful, the range is redefined and bold formatting is applied to the word "blue." With The following example locates the first occurrence of the word "blue" in the active document. If the Find object is accessed from a Range object, the selection is not changed but the Range is redefined when the find criteria is found. FindText:="Hello", _įinding text without changing the selection You can set the individual properties of the Find object or use arguments with the Execute method, as shown in the following example. The Find object includes properties that relate to the options in the Find and Replace dialog box. The following example selects the next occurrence of the word "Hello." If the end of the document is reached before the word "Hello" is found, the search is stopped. If the Find object is accessed from the Selection object, the selection is changed when the find criteria is found.
The find action differs slightly depending upon whether you access the Find object from the Selection object or the Range object. The Find object is available from the Selection object and the Range object. Finding and replacing is exposed by the Find and Replacement objects.
0 kommentar(er)
