Code to clear cells with duplicated conditional formatting

[Ironman]

Hi

My workbook contains a number of sheets.

Two of these, "Training Log" and "Exercise Bike", contain conditional formatting and the rows expand almost daily.

Every time I type in a new row of data to either of these sheets, a new and duplicated Conditional Formatting rule is created for the single cell, even though there is an existing CF rule that includes the newly input data in the range.

I'm not inserting a new row, just typing data into the next empty row.

Assuming there's no way of preventing this annoyance manually (if there is I'd be grateful to know how), I'd appreciate some code that will automatically cleanup any duplicated individual cell CF rules in either of these sheets.

Many thanks.

 

[Yongle]

Which version of Excel are you using?
- I am unable to replicate described behaviour

Suggest you
- delete ALL conditional formatting rules and replace with a new rule applying it to the current active range
- enter data in next row
- the CF range should expand but should not create a new rule

 

[Ironman]

Hi Yongle, many thanks for your help - that worked.