In A1, Conditional formating.. Select 'Formula is' (default is 'cell value is') Enter condition as A2>100. Select the required cell type format. Hope this will work for you. I tried this with OOo 3.1 & Windows XP & is working.
Ashish -----Original Message----- From: Andy Chaplin [mailto:perfect-engl...@gmx.de] Sent: Wednesday, August 12, 2009 1:44 PM To: users@openoffice.org Subject: [users] Conditional Formatting Hi everyone I have a problem with conditional formatting in Calc. I want to apply a style to a cell if the value in another cell meets a certain criteria. For example, I want the style in cell A1 to change if A2 is greater than 100. As far as I can see, it is only possible to apply the condition to the same cell. Have I missed something, or does anyone know a workaround for this? Thanks in advance Andy -- GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT! Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01 --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org Standard Disclaimer Conditions as per Tatachemicals Ltd Email Security Policy apply --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@openoffice.org For additional commands, e-mail: users-h...@openoffice.org