Changing text format with a formula

["Diego Sevilla Ruiz (dsevilla um es)" <dsevilla ditec um es>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1




-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 5.0i for non-commercial use
MessageID: xz1MhzQAqxTcH23jVtElfrvVeL+Bfgzn

iQA/AwUBOoqaTdoq0AfJuWS3EQISawCfSr/TTMzGeEBEYXQb1Pm28OY1ZfgAoOC5
Q+di6pTv982Rjp7W8sfM6OXt
=ZwjT
-----END PGP SIGNATURE-----

--- Begin Message ---

• From: "Diego Sevilla Ruiz (dsevilla um es)" <dsevilla ditec um es>
• To: gnumeric-list gnome org
• Subject: Changing text format with a formula
• Date: Wed, 14 Feb 2001 14:14:56 +0100

Hi all:

    I would like to change a cell's color depending its value.
Somewhat like:

if(A1<1.5,cell(B1).background=red,cell(B1).background=blue)

Is there any way of doing this in gnumeric.

    thanks in advance.
    regards.
    diego.

--
Diego Sevilla Ruiz -- http://ditec.um.es/~dsevilla/ -- dsevilla um es
Dep. Ingeniería y Tecnología de Computadores, Facultad de Informática
Univ.de Murcia,Campus Espinardo,30080 Murcia (SPAIN),Tel.+34968367658
lynx -dump ditec.um.es/~dsevilla/face |uncompface | ikon2xbm |display
PGP:  http://pgp.rediris.es:11371/pks/lookup?op=get&search=0xC9B964B7
perl -e'$_="\x4\ FLe\x2&B";for(/../g){print unpack("b*",$_),"\n"}'|tr 01 " #"

--- End Message ---