Conditional Formating from Drop Down List

S

Sunnyskies

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.
 
B

Bob Phillips

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)
 
D

David Biddulph

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",""))
 
S

Sunnyskies

Great. Have a fantastic holiday.

David Biddulph said:
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",""))
Click to expand...
 
Top