Then select the font or fill color that was created by the conditional formatting.Press the filter drop-down button in the header to open the filter drop-down menu (keyboard shortcut: Alt+Down Arrow).Checkout my 3-Part video series on Filters to learn how to work with Filters. If you are not using a Table then you will need to turn on the Filters for the range. If you are using an Excel Table then the Filters will already be turned on and you will see the Filter Drop-down Menus in the header row of the Table. We can now apply a Color Filter to the column. Step 2: Filter the Column for Font or Fill Color The formatting will be applied to the cells that contain duplicates in the column. Choose the formatting you want to apply and click OK.That will open the Duplicate Values Window.Open the Conditional Formatting drop-down menu.If you are using an Excel Table then you can select any cell inside the column and press Ctrl+Space Bar.Ĭtrl+Space Bar is the keyboard shortcut to select the Entire Column of the Table. The first step is to select the entire column that you want to find duplicates in. Step 1: Apply Conditional Formatting for Duplicates Here are the steps to filter for duplicates with conditional formatting. Checkout my video on a Beginner's Guide to Excel Tables to learn more about this awesome tool. Tables just save a bit of time with this process. I use an Excel Table in this example, but you do NOT need to use Excel Tables for this to work. Thanks again for the great suggestion Jen! □ This technique was suggested by Jen Snyder (a member of the Excel Campus community) on my first video in the 3-part series on Excel Filters. This is quick and easy technique to highlight duplicates and apply a filter to only display the rows that contain duplicates. The video above covers one technique using conditional formatting. There are a lot of ways to find duplicates in your data set. Filter-for-Duplicates-with-Conditional-Formatting.zip Download Filtering for Duplicates
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |