Don’t forget to sign up to the Excel at Excel Newsletter for 3 FREE Excel tips the first Wednesday of the month. Just click on the Sign Up Form to the right or use the link below. You will also receive a copy of my FREE EBOOK of my Top 50 Tips to help you Excel At Excel.

I have been generating a lot of Excel worksheets the past few weeks, and a lot of them have conditional formatting, which got me thinking, it would be really useful to easily highlight any cells that contain conditional formatting. Just follow the instructions below:-

• Hit the F5 key – Special – Select Conditional Formats
• Hit Ok

All of the cells with conditional formatting will be highlighted. Alternatively you can also identify cells that contain the same type of conditional formatting on your Excel worksheet.

Just select Conditional formats then select Same. This is useful if you need to make any amendments or add more cells to the current selection.

Here we can easily identify all of my cells on my worksheet that have conditional formatting. I can now easily copy, change or delete these conditional formats that have been highlighted.

Don’t forget to sign up to the Excel at Excel Newsletter for 3 free Excel tips the first Wednesday of the month. Just click on the Sign Up Form to the right or use the link below.