To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101053 Issue #|101053 Summary|cannot assign cell color to REPLACE ALL items Component|Spreadsheet Version|DEV300m9 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|FEATURE Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|ramjabar
------- Additional comments from ramja...@openoffice.org Mon Apr 13 20:42:33 +0000 2009 ------- I am working in a spreadsheet comparing the values of 2 cells using the EXACT function. If the values are the same, TRUE is displayed. If the values are not the same, FALSE is displayed. With MS Excel I can then do a FIND/REPLACE and replace all occurrences of the word FALSE with another pattern, such as a yellow cell background, so I can spot it easily when scrolling through the spreadsheet. I do not see a way to do this with CALC - it lets me replace a word with another word but not change the characteristics of the cell where the replaced word exists. --------------------------------------------------------------------- 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