| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Drop down list | Excel Discussion (Misc queries) | |||
| Drop Down List choice selecting another drop down list | Excel Worksheet Functions | |||
| Order of drop down list | Excel Discussion (Misc queries) | |||
| Limit drop down list and linking to other info | Excel Worksheet Functions | |||
| changing value of a cell by selecting an item from a drop down list | Excel Worksheet Functions | |||
Linear Mode
