mpkirby wrote:
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" ...
"is greater than or equal to" ... "B1*1.1" ... Cell Style "GE10"
That's exactly what I did. It's weird. I just tried it in a separate
stand-alone spreadsheet, and it works now.
But in my more complex spreadsheet, nothing.
Okay more futzing. Turns out I have some complex macros, so I turned off
automatic updating. But at the time I was manually recalculating. It turns
out that manual recalculation does update macros, but not conditional
formatting.
Further, when you turn recalculation back on again, it doesn't update the
conditional formatting until you update the field. (I didn't try saving and
loading again).
If someone else will confirm this, I'll file a bug with the open office
guys.
Mike
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
the last cell), the conditional formatting did not register the change.
This was canvassed in the Calc forum many months ago and an issue may
have been filed.
I'm not sure it's a legitimate issue. You can force a recalculation
with Shift+Ctrl+F9. Whether that is equal to a change thus removed, I
have never tested.
--
Xfce on PCLinuxOS, OOo 2.0.2 (en_GB).
Direct mail to teaman is not opened; if necessary, email realmail.
If you're seeking, check out http://www.rci.org.au
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]