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