We often search cells
by values or contents in the cells by using find functionality in Excel. But do
you know we can search a cell by format.
Let’s see how? Assume I have a
big client database in Excel and I have highlighted a customer number with
different cell color and with different font format (Bold and Italic). now from
this database if I have to find this different customer, I will use Excel
find functionality
with finding format instead of the content of the cell.
To find the customer number, by format
press Ctrl+F to get Find and Replace pop-up. click on the options button, to
get advanced find options.
When you click on the Options buttons, the Find and Replace pop-up
gets expanded and shows all advanced options.
Click on Format button, and give the kind of format you want to search
in the range.
Excel shows the preview of the format you are going to search in the
range. Press Find Next or Find All and Excel finds all the cells with the same format
you have given in the condition.
Similarly you can give colors in the filter criteria and filter the
range by color.
Important: Clear the format once
you are done with Find operation as Excel may retain the format and search the
same format every time you are using Find functionality.
No comments:
Post a Comment