To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=101991
User regina changed the following: What |Old value |New value ================================================================================ Status|UNCONFIRMED |RESOLVED -------------------------------------------------------------------------------- Keywords|needmoreinfo, oooqa |oooqa -------------------------------------------------------------------------------- Resolution| |WORKSFORME -------------------------------------------------------------------------------- ------- Additional comments from reg...@openoffice.org Mon May 18 12:19:06 +0000 2009 ------- So Yes is a text and you have to put it into double quotes. Your condition would be Cell value is equal to "Yes" This condition is case-insensitive. If you need a case-sensitive solution, then - if your cell is B1 for example - you can use the condition Formula is EXACT(B1,"Yes") The cell reference B1 is written as relative address, and therefore will be adapted when you copy the conditions to other cells. If you have further questions about using conditional formatting, you should ask in a forum or mailing list http://support.openoffice.org/index.html --------------------------------------------------------------------- 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