Hello,
please, I would like to change the color of a range automaticaly according
to an other one, for example : if range A1> 100 then I would like that range
A2 become red.
thanks.

Format>Conditional formatting
select "Formula is" and type:
=A1>100
then select desired format

HTH
--
AP

"ELMOUTTAKI ABDELMAJID" <(E-Mail Removed)> a écrit dans le
message de news: (E-Mail Removed)...
> Hello,
> please, I would like to change the color of a range automaticaly according
> to an other one, for example : if range A1> 100 then I would like that
> range
> A2 become red.
> thanks.
>
>

Just use Conditional Formatting with a condition of greater than and a value
of 100.

--
HTH

Bob Phillips

(remove xxx from email address if mailing direct)

"ELMOUTTAKI ABDELMAJID" <(E-Mail Removed)> wrote in
message news:(E-Mail Removed)...
> Hello,
> please, I would like to change the color of a range automaticaly according
> to an other one, for example : if range A1> 100 then I would like that
range
> A2 become red.
> thanks.
>
>