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" <(E-Mail Removed)> a écrit dans le message de news:
(E-Mail Removed)...
>
> What code would you suggesr?
>
> EJE
>
>
> On Tue, 30 Oct 2007 11:46:19 +0100, "papou"
> <(E-Mail Removed)> wrote:
>
>>Hello
>>See Format, Conditional Formatting
>>
>>HTH
>>Cordially
>>Pascal
>>
>>"Ed" <(E-Mail Removed)> a écrit dans le message de news:
>>(E-Mail Removed)...
>>> Please tell me the code to co;or a font such as:
>>>
>>> If A1 >0 then A1 is colored red
>>>
>>> Thanks,,
>>>
>>> EJE
>>