Changing text format with a formula



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

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 " #"




-----BEGIN PGP SIGNATURE-----
Version: PGPfreeware 5.0i for non-commercial use
MessageID: jyjHzH1MNwOpjhg3Oc4DLFUeEL+kitye

iQA/AwUAOoqE0doq0AfJuWS3EQJWQACdGjlVw8fZpAs90FNQsMOEVqxeeUoAnA9C
XbckefRZb5Q7ZsNQC/P+AS9j
=Rpc+
-----END PGP SIGNATURE-----




[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]