Shading a range of cells

[Slovenc0417 via OfficeKB.com]

I would like to automatically shade a range of cells a certain color based on
data entered into a cell withing that range.

For example, I have a row in which I am entering data, "community name", "lot
number", "buyer name" and weather or not the contract is based on a
"contingency". If the answer is "yes", I want the row to automatically
highlight to red. If the answer is "no", then I want it to highlight to
"green".

I have done this once, but for the life of me, I can not rememer how.

Thanks for any help.

Rob

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200602/1

[bj]

check out <format><conditional format>
use fomula is referencing the cell of interest

"Slovenc0417 via OfficeKB.com" wrote:

> I would like to automatically shade a range of cells a certain color based on
> data entered into a cell withing that range.
>
> For example, I have a row in which I am entering data, "community name", "lot
> number", "buyer name" and weather or not the contract is based on a
> "contingency". If the answer is "yes", I want the row to automatically
> highlight to red. If the answer is "no", then I want it to highlight to
> "green".
>
> I have done this once, but for the life of me, I can not rememer how.
>
> Thanks for any help.
>
> Rob
>
> --
> Message posted via OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...excel/200602/1
>