Conditional Formating from Drop Down List
 

Afternoon,

I have a drop down list with five options in cell H3:
Accident Damage
Transferred From
Transferred To
Operational
Service

Now in a seperate cell (L3) I want to use conditional formating so that when
Transferred From is selected, then in the cell it will say "Sending Depot" in
Red and when Transferred To is selected, then the cell will say "Receivig
Depot" in Green.

Any suggestions.

Oh yes, forgot, compliments of the season.

Conditional Formating from Drop Down List
 

You need a formula in L3 of

=IF(H3="Transferred From","Sending Depot",IF(H3="Transferred To","Receiving
Depot,""))

and then conditionally format L3 to show the colour based upon that value.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Sunnyskies" wrote in message
...
Afternoon,

I have a drop down list with five options in cell H3:
Accident Damage
Transferred From
Transferred To
Operational
Service

Now in a seperate cell (L3) I want to use conditional formating so that
when
Transferred From is selected, then in the cell it will say "Sending Depot"
in
Red and when Transferred To is selected, then the cell will say "Receivig
Depot" in Green.

Any suggestions.

Oh yes, forgot, compliments of the season.

Conditional Formating from Drop Down List
 

Thanks, works like a dream

"Bob Phillips" wrote:

You need a formula in L3 of

=IF(H3="Transferred From","Sending Depot",IF(H3="Transferred To","Receiving
Depot,""))

and then conditionally format L3 to show the colour based upon that value.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Sunnyskies" wrote in message
...
Afternoon,

I have a drop down list with five options in cell H3:
Accident Damage
Transferred From
Transferred To
Operational
Service

Now in a seperate cell (L3) I want to use conditional formating so that
when
Transferred From is selected, then in the cell it will say "Sending Depot"
in
Red and when Transferred To is selected, then the cell will say "Receivig
Depot" in Green.

Any suggestions.

Oh yes, forgot, compliments of the season.

Conditional Formating from Drop Down List
 

Sorry Bob,

How do I elimate the FALSE from the error calculation?

Thanks

"Bob Phillips" wrote:

You need a formula in L3 of

=IF(H3="Transferred From","Sending Depot",IF(H3="Transferred To","Receiving
Depot,""))

and then conditionally format L3 to show the colour based upon that value.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Sunnyskies" wrote in message
...
Afternoon,

I have a drop down list with five options in cell H3:
Accident Damage
Transferred From
Transferred To
Operational
Service

Now in a seperate cell (L3) I want to use conditional formating so that
when
Transferred From is selected, then in the cell it will say "Sending Depot"
in
Red and when Transferred To is selected, then the cell will say "Receivig
Depot" in Green.

Any suggestions.

Oh yes, forgot, compliments of the season.

Conditional Formating from Drop Down List
 

Include the missing double quotes at the end of "Receiving Depot" and before
the comma.
=IF(H3="Transferred From","Sending Depot",IF(H3="Transferred To","Receiving
Depot",""))
--
David Biddulph

"Sunnyskies" wrote in message
...
Sorry Bob,

How do I elimate the FALSE from the error calculation?

"Bob Phillips" wrote:

You need a formula in L3 of

=IF(H3="Transferred From","Sending Depot",IF(H3="Transferred
To","Receiving
Depot,""))

and then conditionally format L3 to show the colour based upon that
value.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Sunnyskies" wrote in message
...
Afternoon,

I have a drop down list with five options in cell H3:
Accident Damage
Transferred From
Transferred To
Operational
Service

Now in a seperate cell (L3) I want to use conditional formating so that
when
Transferred From is selected, then in the cell it will say "Sending
Depot"
in
Red and when Transferred To is selected, then the cell will say
"Receivig
Depot" in Green.

Any suggestions.

Oh yes, forgot, compliments of the season.

Conditional Formating from Drop Down List
 

Great. Have a fantastic holiday.

"David Biddulph" wrote:

Include the missing double quotes at the end of "Receiving Depot" and before
the comma.
=IF(H3="Transferred From","Sending Depot",IF(H3="Transferred To","Receiving
Depot",""))
--
David Biddulph

"Sunnyskies" wrote in message
...
Sorry Bob,

How do I elimate the FALSE from the error calculation?

"Bob Phillips" wrote:

You need a formula in L3 of

=IF(H3="Transferred From","Sending Depot",IF(H3="Transferred
To","Receiving
Depot,""))

and then conditionally format L3 to show the colour based upon that
value.

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Sunnyskies" wrote in message
...
Afternoon,

I have a drop down list with five options in cell H3:
Accident Damage
Transferred From
Transferred To
Operational
Service

Now in a seperate cell (L3) I want to use conditional formating so that
when
Transferred From is selected, then in the cell it will say "Sending
Depot"
in
Red and when Transferred To is selected, then the cell will say
"Receivig
Depot" in Green.

Any suggestions.

Oh yes, forgot, compliments of the season.