Hi EJE
There is no need for code for what you want to achieve.
This is an Excel built-in function available from the Excel menu:
Format, Conditional formatting

HTH

Cordially
Pascal


"Ed" a écrit dans le message de news:
...

What code would you suggesr?

EJE


On Tue, 30 Oct 2007 11:46:19 +0100, "papou"
wrote:

Hello
See Format, Conditional Formatting

HTH
Cordially
Pascal

"Ed" a écrit dans le message de news:
...
Please tell me the code to co;or a font such as:

If A1 0 then A1 is colored red

Thanks,,

EJE