Written by Allen Wyatt (last updated January 29, 2022)
This tip applies to Excel 2007, 2010, 2013, 2016, 2019, 2021, and Excel in Microsoft 365
Vanita asked if there is a way to select cells containing a specific color. (I'm talking background color here, not text color.) Accomplishing the task is easy; just follow these steps:
Figure 1. The Find tab of the Find and Replace dialog box.
Figure 2. The Fill tab of the Find Format dialog box.
Figure 3. The expanded Find and Replace dialog box.
Note:
ExcelTips is your source for cost-effective Microsoft Excel training. This tip (6224) applies to Microsoft Excel 2007, 2010, 2013, 2016, 2019, 2021, and Excel in Microsoft 365. You can find a version of this tip for the older menu interface of Excel here: Finding Cells Filled with a Particular Color.
Solve Real Business Problems Master business modeling and analysis techniques with Excel and transform data into bottom-line results. This hands-on, scenario-focused guide shows you how to use the latest Excel tools to integrate data from multiple tables. Check out Microsoft Excel 2013 Data Analysis and Business Modeling today!
If you need to replace information that may appear in cells, comments, and text boxes, your best bet is to use a macro. ...
Discover MoreSearching for information in an Excel worksheet generally goes very smoothly. There can be times, however, when the ...
Discover MoreReplacing a specific character (such as a tilde) seems a simple task, until you need to replace it only in a certain ...
Discover MoreFREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
There are currently no comments for this tip. (Be the first to leave your comment—just use the simple form above!)
Got a version of Excel that uses the ribbon interface (Excel 2007 or later)? This site is for you! If you use an earlier version of Excel, visit our ExcelTips site focusing on the menu interface.
FREE SERVICE: Get tips like this every week in ExcelTips, a free productivity newsletter. Enter your address and click "Subscribe."
Copyright © 2025 Sharon Parq Associates, Inc.
Comments