Wolf Rogner (war-rsb), if one wants to use Conditional Formatting to change the background of cell A1 containing an uppercase A to green, and cell A2 containing an uppercase B to yellow one may perform at the Terminal:
localc -nologo highlight cells A1 through A3 -> click Format -> Conditional Formatting... -> Condition 1 checkbox checked -> Cell value in dropdown box -> equal to in dropdown box -> in field type "A" (include the double quotes) -> click New style... button -> in Cell Style window click Background tab -> click Green -> click OK button -> Condition 2 checkbox checked -> Cell value is in dropdown box -> equal to in dropdown box -> in field type "B" (include the double quotes) -> click New style... button -> in Cell Style window click Background tab -> click Yellow -> click OK button -> in Conditional Formatting window clicked OK button and notice A1 background is green, A2 is yellow, and A3 is not changed. lsb_release -rd Description: Ubuntu oneiric (development branch) Release: 11.10 apt-cache policy libreoffice-calc libreoffice-calc: Installed: 1:3.4.2-2ubuntu3 Candidate: 1:3.4.2-2ubuntu3 Version table: *** 1:3.4.2-2ubuntu3 0 500 http://us.archive.ubuntu.com/ubuntu/ oneiric/main i386 Packages 100 /var/lib/dpkg/status -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/631857 Title: Conditional Formatting does not work properly To manage notifications about this bug go to: https://bugs.launchpad.net/df-libreoffice/+bug/631857/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs