Select/Replace/Find Similar Format Cells

Some times people need to select similar format cells for analysis purpose or for editing the cells Now the question raise "How they can do this?" there is a simple process to this in excel same is defined here below. 1. Press "Ctrl + F" 2. Press "Options>>" 3. Click the arrow to the right of “Format” button (located at the right of the “Find what:” text box) 4. Select “Choose Format From Cell” (you can do it manually by using “Format” option instead) 5. Select the cell with the target format to select. The format is previewed at the right of “Find what:” text box 6. Press “Find All”. All the cells with the selected format are shown in the pane 7. Pick cells individually or press CTRL to select more than one to do the required action: replace, find, etc

one more important thing any one has to keep in mind while doing this is for using the find and replace command you have to select "clear find format".

Hope this tip will help you out some what.