To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=77740 Issue #|77740 Summary|Conditional formatting is tempremental Component|Spreadsheet Version|OOo 2.1 Platform|Macintosh URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|cfleming2691
------- Additional comments from [EMAIL PROTECTED] Thu May 24 03:24:37 +0000 2007 ------- Set up a conditional formatting style for a cell with a red background. Enter the values 3 in B5, 10 in B7, and 11 in D7. Conditionally format cell D7 to turn red if it's value is less than SUM(OFFSET(D4;0;1;1;$B5))+$B7 Enter the values 1 in E4 and 1 in F4: Cell D7 should turn red but it does not. Move the active cell to the right until cell D7 disappears from view and then move the active cell back to D7. Cell D7 is now red. Delete the value 1 from cell F4. The red background from cell D7 should disappear but it does not. Move the active cell to the right until cell D7 disappears from view and then move the active cell back to D7. The red background from cell D7 now disappears. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]