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 -- View this message in context: http://www.nabble.com/Conditional-Formatting-in-Calc-tf2748429.html#a7669859 Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
