Changing text format with a formula
- 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
-----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]