Finding cells with conditional formatting in Excel

It can be difficult to know how to find which cells have conditional formatting, especially in version 2003.  The instructions to do so are below.

Looking for Microsoft Excel training? Click here for our courses.

  

Version 2003

Click any cell.

If you wish to find cells that have the same conditional formatting settings as a particular cell, then click that cell.

Click Edit

Click Go to

Click Special

Click Conditonal formats

If you are searching for cells with any conditional formatting, click All below Data validation.

If you are searching for cells with conditional formatting identical to the selected cell, click Same below Data validation.

  

Verison 2007 / 2010

To find all cells which have conditional formatting:

Click any cell which doesn't have conditional formating

On the Home tab, click the drop-down arrow next to Find & Select,  then click Conditional Formatting.

  

To find cells with the same conditional format as a cell:

Click the cell which has the conditional format you wish to find.

On the Home tab, click the drop-down arrow next to Find & Select, then click Go To Special.

Click Conditional formats then click Same under Data validation.

  

  

Nicholas Jankovic

T7 Training Systems

  

Tuesday, 3rd January 2012

 

HomeInformation and pricingCoursesMake a bookingBlogContact us
© 2011 T7 Training Systems

Magicdust Responsive Website Design

HomeInformation and pricingCoursesMake a bookingBlogContact us