Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-19-2017, 06:06 AM
ewso ewso is offline conditional formatting macro Windows 10 conditional formatting macro Office 2016
Advanced Beginner
conditional formatting macro
 
Join Date: Nov 2016
Posts: 80
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 conditional formatting macro Windows Vista conditional formatting macro Office 2007
Expert
 
Join Date: Apr 2016
Posts: 673
jeffreybrown has a spectacular aura aboutjeffreybrown has a spectacular aura about
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 conditional formatting macro Windows 10 conditional formatting macro Office 2016
Advanced Beginner
conditional formatting macro
 
Join Date: Nov 2016
Posts: 80
ewso is on a distinguished road
Default

The second code worked! Jeffrey thanks
Reply With Quote
Reply

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 macro Conditional formatting marif300 Project 9 09-23-2014 07:23 AM
conditional formatting macro 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 macro Conditional Formatting and/or Macro for Character Insertion? MonOverArchIng Word 2 01-11-2013 02:48 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:34 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft