contender wrote:
>
>
>
> Conditional formatting recalculates normally.
>
> I found an instance where it does not. That was a case where the cell
> contained a formula referencing the last cell in a column. When the
> column was extended (so that, consequentially, a different cell became
Joe Smith-4 wrote:
>
>
> First you have to define a named style. You can format a cell as you
> want it to look, then use the Stylist (F11) to define a style from the
> current cell. Give your style a name, e.g. "GE10".
>
> In the Format > Conditional Formatting dialog, choose "Cell Value" .
I'm using neo office (open office 2.0.3 based), and I'm having difficulty
with conditional formatting.
I want the text in a cell to be red if the value in it is more than 10% over
the value in the neighboring cell.
So I do something like Cell Value, greater than, m5*1.1 (or whatever the
neighbor