No formula, conditional formatting. See
http://www.contextures.com/xlCondFormat01.html

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"mohd21uk via OfficeKB.com" <u20517@uwe wrote in message
news:5f0408528356e@uwe...
I would like to change a cell's background colour if a certain value is
entered in another cell. For e.g., if Yes is entered in cell a5 i would
like
to have cell c9 in green. I would be grateful if you could provide me a
formula that could do this for me.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200604/1