• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Can you delete conditional formatting commands from multiple sheets

Can I delete certain commands all at once? Like I need to delete all the =IF(AND($A$3="?",$L$3="?"),1,"") (=$AC$11:$AD$15) from all 10 sheets on about 35 rows
 
Hi Jack,
I have found this while googling:
  1. Click a cell that has the conditional format you want to remove throughout the spreadsheet.
  2. On the Home tab, click the arrow next to Find & Select, and then click Go To Special.
  3. Click Conditional formats.
  4. Click Same under Data validation.
All the cells that contain the same conditional formatting rules are selected.

  1. On the Home tab, click Conditional Formatting > Clear Rules > Clear Rules from Selected Cells.
Regards,
 
Back
Top