To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=114747
Issue #|114747
Summary|Feature request - allow cell selection from conditiona
|l format code
Component|Spreadsheet
Version|OOo 3.1
Platform|All
URL|
OS/Version|Windows XP
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|formatting
Assigned to|spreadsheet
Reported by|smdear
------- Additional comments from smd...@openoffice.org Sat Sep 25 21:12:22
+0000 2010 -------
I would like to have all dates in a particular column have different colors
depending on a criteria specified in a conditional format code.
However, the worksheet is intended on being copied/pasted into a new sheet
biweekly, and to reduce rework I would like the conditional format code to be
able to draw information from other cells in the worksheet rather than being
hardcoded.
For example, in a particular worksheet I want all dates on or before Sep 30/2010
to have green color, and any date later than Sep 30/2010 to have red color.
Column A Column B
Row 1 Date Numeric equivalent
Row 2 Sep 30, 2010 40451
Row 3 Aug 31/2010
Conditional format code used with current software by selecting cell A3,
Format->Cells->Format code:
[<=40451][GREEN]MMM D, YYYY;[>40451][RED]MMM D, YYYY
What I would like to be able to specify is the following:
[<=B2][GREEN]MMM D, YYYY;[>B2][RED]MMM D, YYYY;General
Then, whenever the value of B2 changes the highlighting would change for all
formats that reference this cell.
---------------------------------------------------------------------
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: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
