Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel Programming

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-19-2017, 06:06 AM
ewso ewso is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Nov 2016
Posts: 72
ewso is on a distinguished road
Default conditional formatting macro

Is there a macro that can remove the conditional formatting from all blank cells in a worksheet?



thanks
Reply With Quote
  #2  
Old 09-19-2017, 03:05 PM
jeffreybrown jeffreybrown is offline Windows Vista Office 2007
Expert
 
Join Date: Apr 2016
Posts: 331
jeffreybrown is on a distinguished road
Default

Maybe one way could be...

Code:
Sub Macro1()
    Cells.SpecialCells(xlCellTypeBlanks).ClearFormats
End Sub
or

Code:
Sub Macro2()
    Cells.SpecialCells(xlCellTypeBlanks).FormatConditions.Delete
End Sub
Reply With Quote
  #3  
Old 10-05-2017, 12:10 AM
ewso ewso is offline Windows 10 Office 2016
Advanced Beginner
 
Join Date: Nov 2016
Posts: 72
ewso is on a distinguished road
Default

The second code worked! Jeffrey thanks
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting Macro grexcelman Excel Programming 1 01-10-2015 04:45 PM
Conditional formatting marif300 Project 9 09-23-2014 07:23 AM
Conditional formatting that ignores other formatting rules info_guy2 Excel 1 07-03-2014 10:07 AM
Conditional Formatting jdc15371 Excel 2 06-26-2014 06:34 AM
Conditional Formatting and/or Macro for Character Insertion? MonOverArchIng Word 2 01-11-2013 02:48 AM


All times are GMT -7. The time now is 03:25 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft