cHANGIN A CELL COLOUR BASED ON A CELL VALUE

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

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