I have the following formula which highlighs the lowest five of ten numbers.

=ISNUMBER(MATCH(H10,SMALL($H10:$Z10,COLUMN($A:$E)) ,0))

All works well until I Save and exit. When I re-open the worksheet the
highlighting is gone.

I can then go to CD - Manage Rules - Edit Rule - Apply and OK. At this
point, all formatting reappears.

This happens on all worksheets.

Any ideas?

Bob