Remove CF from single cell

[klynshoe]

I have CF applied against an entire worksheet and want to keep it that way with the exception of a single cell. Is there a way to remove this particular cell from the data range?

USING EXCEL 2007

 

[VoG]

Maybe

ActiveCell.FormatConditions.Delete

 

[klynshoe]

How do I run that? I'm not too familiar with VBA.

 

[shg]

From the UI, if you're using Excel 2007+, Conditional Formatting > Clear Rules > from Selected Cells

 

[AlisaA]

Conditional Formatting on the Home toolbar gives the option Clear Rules / Clear Rules from Selected Cells. Does that work for you?

 

[klynshoe]

Shg - this works wonderfully thanks!