How to select cells based on color or formatting

Excel makes it possible to select cells based on the formatting of other cells. There are several steps you need to follow:

Step 1: On Home tab, go to Find and Replace, select Find option, you can also quickly activate this Find option by pressing Ctrl+F shortcuts.

Step 2: Click Format button in the Find and Replace dialog box, and select Choose Format From Cell (to select the format of a specific cell, if you just want to define your format, click Format). If you can’t find out the Format button, please click the Options button first.



Step 3: Select the cell contains the format you want to use for searching, and then click the Find All button. All cells which have the same formatting with the selected cell will be list under the list box, see screenshot:




Step 4: Press Ctrl + A to select all the items in the list box, and the same formatting cells with the selected cell have been selected including the specific cell.