Conditional Formating from Drop Down List

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 
Sorry Bob,

How do I elimate the FALSE from the error calculation?

Thanks
 
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",""))
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formula formatting 2
Data Validation/Conditional Formating 3
Conditional Drop Down List 2
Excel Formatting in Drop Down Lists 2
Filtered drop down list 2
Drop down list reference 1
I am trying to create a drop down list with format 1
Drop down list 1

Back
Top