Format cell based on another cell's value

  • Thread starter Thread starter Barney
  • Start date Start date
B

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