This would still be conditional formatting. In this case, Select your target
cell, change condition 1 to Formula Is and add a formula of say =A1=17,
select the pattern tab and choose the colour.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"kraft " wrote in message
...
Hi... I've read the post about changing bg color when a value is entered
but that applies on the same cell, problem is I don't know how to
change bg color of another cell when a value is entered in another
cell.
Anybody??

Thanks...


---
Message posted from http://www.ExcelForum.com/