Format cell based on another cell's value

[Barney]

How do I change the background color of cell A4 based on the value in cell
D7?

i.e. If D7 = 3; A4 background should be green.

Thanks in advance and Merry Christmas.

Barney

 

[Paul B]

Barney, click in A4 and format, conditional formating, change cell valve is
to formula is and put =$D$7=3, format to green, OK

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Barney]

Thanks Paul, that worked perfectly.

Merry Christmas.

Barney