auto format

O

One-Leg

Hello,

How can I make two cells become green (or what ever the color) when one of
them has a specific value?

For example, if I have the number 5 in cell A2, I want cells A1 and A2 to be
in green...

Thanks!!!
 
G

Gordon

One-Leg said:
Hello,

How can I make two cells become green (or what ever the color) when one of
them has a specific value?

For example, if I have the number 5 in cell A2, I want cells A1 and A2 to
be
in green...

Thanks!!!

Look up conditional formatting.
 
Top