Additional note. Don't forget to set the format options. Use the Pattern
tab to set the cell color.

--

"PCLIVE" wrote in message
...
Use Conditional Formatting from the Format menu.

Select D1.
Goto Format-Conditional Formatting

Select Formula Is
Then enter this: =A1="Collateral"

HTH,
Paul

--

"srain001" wrote in message
...
Hi,

I'm looking for a way to change the color of one cell when a specific
value
in another is entered.

For example, if A1 is equal to "Collateral", I would like D1 to become
RED.

Help please!
Thanx!
Srain