1) First, make sure you have a named style... 2) For purpose of illustration - set a value to some cell - A1 to 3
3) Select the row you want to apply the condition. 4)Open conditional formatting dialog 5) In Condition 1, select Formula Is 6) As condition, enter $A$1=3 (absolute addressing required!) 7) Set Cell STyle to previous named style. 8) Select OK - and you're done. 4) Ope On 9/28/05, Pere Castañer Sarda <[EMAIL PROTECTED]> wrote: > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi people, > > I'm trying to create a conditional format that when it became true the > cell style of the entire row or column is modified. I think that it's not > possible, isn't it? > > Thanks for you time. > > PS:Pst, if not possible do you think that is a good feature and you will > vote it in new features' list? > - ---- > - -- > Pere Castañer Sardà > Servei informàtic DIBOSCH S.L > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.4.1 (GNU/Linux) > > iD8DBQFDOqJuz9pL9wbHcwIRAq+jAJ9qfIkWBFpcG4yYt/2AVuDAsJKbRQCaAjYV > 8kHLQoayWPQ8n/guCsW7aIo= > =bSMv > -----END PGP SIGNATURE----- > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- My OpenOffice Calc Website http://www.openofficetips.com
