Here we come up with the clear-cut instructions to Select Cells Based on Color or Formatting in Excel Office 365 using Kutools. Let’s see them below!! Get an official version of MS Excel from the following link: https://www.microsoft.com/en-in/microsoft-365/excel
Note: kutools for Excel has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.
Select All Cells with Similar Formatting:
To select cells with the same formatting in an Excel spreadsheet, follow the below steps.
- Let’s consider an example of data to know how this utility works.
- In the below image, you can see the example values and some values are in italic & bold formatting.
- Go to the Kutools Tab, click on the Select option, then choose the Select Cells with Format option.
- It will open the Select Cells with Format Dialog Box.
- Find Range – You need to specify the input range using the browse button.
- Then, you need to click on the Choose Format From Cell button to select a cell that you want to use its formatting.
- Type – Here, all attributes of the base cell are displayed in the below list box. If you want to select all cells with the same formatting as the base cell, check all attribute options.
- Ignore the blank cells – You can use this option if the range has blank cells and you don’t want to select them.
- Then, click the OK button.
- A prompt box will pop-out to tell you how many cells will be selected from the range.
- Click the Yes button if you want to select the cells. Otherwise, you can click No option to search again.
- You can get the result as shown in the below image.
Steps to Select All Cells by Color of a Cell:
If you want to select all cells based on the color of a cell from the range, do as follows.
- In the below screenshot, you can see the input cells and some of them have cell color.
- To select cells based on the cell color, go to the Kutools Tab, click on the Select option, choose the Select Cells with Format option from the menu.
- It will open the Select Cells with Format Dialog Box.
- Find Range – You need to specify the input range using the browse button.
- Then, you need to click on the Choose Format From Cell button to select a cell that you want to use its formatting.
- Type – Here, all attributes of the base cell are displayed in the below list box. If you want to select all cells with the same formatting as the base cell, check all attribute options.
- Ignore the blank cells – You can use this option if the range has blank cells and you don’t want to select them.
- Then, click the OK button.
- It will open the prompt box to show you how many cells have been selected.
- Hit the OK button to close the prompt box and see the result.
- Click the Yes button if you want to select the cells. You can click No option to search again.
- Finally, you can get the result as shown in the below image.
End of the Article:
In this article, you can easily understand the steps to Select Cells Based on Color or Formatting in Excel Office 365 using Kutools. ** Give your **suggestions/feedback in the comment section. Thanks for visiting Geek Excel. Keep Learning!
Top comments (0)