Change the Color of the range

  • Thread starter ELMOUTTAKI ABDELMAJID
  • Start date
E

ELMOUTTAKI ABDELMAJID

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.
 
A

Ardus Petus

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

HTH
 
B

Bob Phillips

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)
 
Top