Conditional Formatting and the F4 key

[jammin7800]

Excel 2007

The F4 key has long been my friend, repeating the last action in Excel. What a great time saver. But I notice there are instances where it won't repeat, and I'm wondering if there are workarounds for this, or maybe additional shortcut keys that need to be used.

It's regarding Conditional Formatting. Specifically, Clearing Conditional Formats from specified cells. I have ALOT of cells to clear conditional formatting from, but, unfortunately, they are not adjacent cells. So, I end up selecting two cells, go to the pull down, hit CF, scroll down to "Clear Rules," then click on "Clear Rules from Selected Cells", and then move on. And repeat. And repeat. And .....

If I could just select the cells and hit F4 (after doing the menu selections once, of course) that would be so much quicker. But it doesn't work that way.

Any thoughts on this?

 

[Ropes4u]

Do you want to clear all conditional formatting on the sheet? Or only on selected ranges?

assign this to a menu item or button - might want to make it smarter.

Sub Macro1()

Selection.FormatConditions.Delete

End Sub

 

[jammin7800]

Got it! Thanks! Exactly what I needed!