Cell colors
 

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

Cell colors
 

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

Cell colors
 

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

Cell colors
 

Hi,

Go to D1 Format Conditional Formatting
Formula Is
=A1="Collateral"
Format Pattern Red ...

HTH

Cell colors
 

See also your other post about a pop-up message.


Gord Dibben MS Excel MVP

On Fri, 14 Dec 2007 07:07:03 -0800, srain001
wrote:

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