[python-win32] XL Worksheet and formulas
Kojo Idrissa
kojo at hal-pc.org
Thu Dec 18 02:32:47 EST 2003
John,
If you're just trying to do it in Excel (no Python), you can just use
Conditional Formatting.
If you're trying to do it in Python, I think you'd have to use Python
to alter the value of the FontColorIndex attribute, based on the value
in the cell.
If you want code (in VB or Python), I may be able to come up with
something. The "Excel Only" version needs no code.
On Thu, 18 Dec 2003 02:30:13 +0100
"John A.Simonsen" <jasimons at online.no> wrote:
]Hi there.
]
]I wondered if you or anybody knows how to make the numbers in a cell
]to change color.
]Problem!!! I want the numbers in the cell(s) to change color if the
]value is zero, or have a negative value.
]
]Is there anybody that can help me out here??? I have spent a lot of
]time trying to find a way, but I still haven’t had any success.
]
]Best regards. Phone. +47 51 62 70 98
] Cell Phone. +47 913 20 009
]
]John A. Simonsen. Fax. +47 51 97 77 56
]jasimons at online.no Fax. +47 51 68 99 05
]☺
]
]
****************************
Kojo Idrissa
kojo at hal-pc.org
http://www.hal-pc.org/~kojo
****************************
More information about the Python-win32
mailing list