Conditional formatting cold be more simple to use. Right now it is a bit 
complicated and it is just as primitive as the MS Excel one. To do it I must 
first define a "Cell style". Why not just include a "New style" button next to 
the Cell style selector of the conditional formatting dialog? Almost everytime I 
want to use conditional formatting I select a range of cells, then format - 
conditional format. Then I enter Condition 1 and when I look for a proper cell 
style I find that I have to make a new one, so I have to leave the conditional 
formatting dialog, create a new cell style and then back again. A lot of work 
with a minimum of result... A "new style" button would make it a lot easier.
 
So I said it's just as primitive as MS Excel's version. Why not an unlimited 
number of conditions? Three is not good enough, is it? To me the conditional 
formatting seems to be just stolen from Excel. No new fresh ideas at all.
 
Right now the conditional formatting dialog looks something like this:
 
Condition 1
Three main buttons: "OK", "Cancel" and "Help".

Input field:
"Cell value is"
"Formula is"

Condition field:
"Equal to"
"Less than"
"Greater than"
"Less than or equal to"
"Greater than or equal to"
"Not equal to"
"Between"
"Not beetween"
 
Formula input field
 
Cell style selection field
 
Then the same for condition 2 and 3.

 
 
My suggestion:
Main buttons: "OK", "Cancel", "New condition" and "Help"
 
Condition select field (to select condition 1, 2, 3... depending on how many 
conditions you created)

Left expression input field (where you can enter an expression, a cell address 
or "this cell" or something like that)

Condition field:
"Equal to"
"Less than"
"Greater than"
"Less than or equal to"
"Greater than or equal to"
"Not equal to"
"Between"
"Not beetween"
 
Formula field (where you enter the expression to be compared to the selected 
cell in "Cell select" above)

Cell style selection field
"New cell style" button (if you don't wanna use one of the selectable styles, 
you can just make a new one).

Here's one more detail, which could sound like another issue, but it doesn't 
appear (as far as I know) unless conditional formatting is used:
When creating a style containing change of borders, there shouldn't only be 
different kinds of lines. There should also be a "don't change" option.

An example:
I want to underline a part of a row which fulfills certain conditions so I 
create a cell style making sure it contains a border at the bottom of the cell. 
However there are vertical lines involved, so when the condition is fulfilled by 
a cell and it has a vertical line, this vertical line disappears, since the cell 
style doesn't include it.

Johnny Andersson