Alec, the code worked for me

Do you get a subscript out of range error? If so, are you
sure there are 2 format conditions?



-----Original Message-----
The Following code removes all formats in a selected
range:-

"Selection.FormatConditions.Delete"

How do I modify it to remove format condition 2, the
following does not work:-

"Selection.FormatConditions(2).Delete

Thanks
Alec


..


.