Cell colors

's Computer Specifications

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

's Computer Specifications

Use Conditional Formatting from the Format menu.

Select D1.
Goto Format->Conditional Formatting

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

HTH,
Paul

--

"srain001" <(E-Mail Removed)> wrote in message
news:02127691-DF6E-4CFF-835D-(E-Mail Removed)...
> 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

's Computer Specifications

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

--

"PCLIVE" <pclive(RemoveThis)@cox.net> wrote in message
news:(E-Mail Removed)...
> Use Conditional Formatting from the Format menu.
>
> Select D1.
> Goto Format->Conditional Formatting
>
> Select Formula Is
> Then enter this: =A1="Collateral"
>
> HTH,
> Paul
>
> --
>
> "srain001" <(E-Mail Removed)> wrote in message
> news:02127691-DF6E-4CFF-835D-(E-Mail Removed)...
>> 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
>
>

's Computer Specifications

Hi,

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

HTH

's Computer Specifications

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
<(E-Mail Removed)> 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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Dynamically setting CELL COLORS based on TWO OTHER cell values	Tom	Microsoft Excel Misc	4	23rd Feb 2009 03:48 PM
Automatically change cell colors based on date in cell	Greg	Microsoft Excel Misc	1	27th Jan 2009 05:53 PM
Cell colors or text color changing when date in cell gets closer.	=?Utf-8?B?Q2hhc2U=?=	Microsoft Excel Worksheet Functions	5	19th Oct 2006 08:57 AM
Can't format font colors or cell fill-in colors	=?Utf-8?B?Y2Fub2Vyb24=?=	Microsoft Excel Misc	3	22nd Aug 2005 11:46 PM
Alternating cell shading colors for every other merged cell	james545@my-deja.com	Microsoft Excel Misc	1	27th Oct 2003 08:09 PM