A.) THE PROBLEM

Lets suppose we want to do some useful, but more complex Conditional Formatting:

1.) suppose we want to identify every *start* of a new series of records (rows)
 - suppose row 1 is the header row
 - we select everything (except row 1), and enter the following
   conditional formatting, based on the formula:
   =IF($A1 = $A2; FALSE; TRUE)
  [as said, A1 was not selected]
 - IF a number of rows delimit unique items, than we need slightly
   more complex formulas:
   =IF(CONCATENATE($A1; $B1; ...) = CONCATENATE($A2; $B2; ...); FALSE; TRUE)

2.) suppose we create a really complex conditional formatting schema
[Actually, I think this is not possible yet in OOo, but I often do such work in
Excel 2007.]

3.) suppose now that we want to apply this conditional formatting to multiple
sheets and spreadsheets.

I want to have this conditional formatting schema applied easily to different
spreadsheets.

B.) SOLUTION
From my point of view, I would like something like CSS within HTML: separate the
2 layers: *Content* and *Conditional Formatting*.

1.) This needs ODF-changes, too: add a separate stream for conditional formatting.

2.) Allow exporting/importing the conditional formatting stream. This way, it
becomes easy to clone the conditional formatting to different sheets, and to
apply minor tweaks to this formatting.

This would greatly enhance the conditional formatting experience.