Conditional Formatting Lost

K

kathleane

Running Excel 2000 in Windows ME.

When I right click and choose INSERT which inserts a row above a row
that has conditional formatting about 1/2 the time the conditional
formatting is lost in the row below the newly inserted row. What causes
this and if not known could you suggest a workaround?

Also is there a way to force the formatting on newly inserted rows?
 
Top