SOLVED

Excel - Drop-Down & If Statements

%3CLINGO-SUB%20id%3D%22lingo-sub-2625400%22%20slang%3D%22en-US%22%3EExcel%20-%20Drop-Down%20%26amp%3B%20If%20Statements%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2625400%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20new%20in%20this%20community%20-%3C%2FP%3E%3CP%3EOn%20the%20attached%20spreadsheet%3A%3C%2FP%3E%3CP%3E1%20-%20Scope%20Drop-down%2C%20want%20more%20choices%2C%20it%20gives%20me%20only%20one.%3C%2FP%3E%3CP%3E2%20-%20Want%20cell%20color%20under%20Status%20to%20turn%20Red%20if%20Date%20Received%20is%20Blank%2C%20and%20turn%20Green%20if%20date%20is%20filled.%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%20-%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2625400%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECommunity%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2628276%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Drop-Down%20%26amp%3B%20If%20Statements%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2628276%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1123365%22%20target%3D%22_blank%22%3E%40BigBolbol%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello!%20You've%20posted%20your%20question%20in%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Ftech-community-discussion%2Fbd-p%2FCommunityQuestions%22%20target%3D%22_self%22%3ETech%26nbsp%3BCommunity%20Discussion%20space%3C%2FA%3E%2C%20which%20is%20intended%20for%20discussion%20around%20the%20Tech%20Community%20website%20itself%2C%20not%20product%20questions.%20I'm%20moving%20your%20question%20to%20the%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3EExcel%20space%3C%2FA%3E%20-%20please%20post%20Excel%20questions%20here%20in%20the%20future.%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2628983%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Drop-Down%20%26amp%3B%20If%20Statements%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2628983%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1123365%22%20target%3D%22_blank%22%3E%40BigBolbol%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E1)%20Multiple%20selection%20from%20drop-down%20list%20that's%20with%20VBA%20programming%2C%20the%20sample%20is%20here%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fwww.contextures.com%2Fexcel-data-validation-multiple.html%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EExcel%20Data%20Validation%20Drop%20Down%20Select%20Multiple%20Items%20(contextures.com)%3C%2FA%3E%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E2)%20Since%20there%20are%20only%20two%20options%20with%20color%2C%20you%20color%20range%20in%20red%20first%20and%20after%20that%20apply%20conditional%20formatting%20rule%20as%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20789px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F301882i02961AF02E530C43%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2635247%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Drop-Down%20%26amp%3B%20If%20Statements%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2635247%22%20slang%3D%22en-US%22%3EHi%20Sergai%2C%3CBR%20%2F%3EThanks%20for%20your%20response.%3CBR%20%2F%3EI%20followed%20the%20steps.%20Unable%20to%20attach%20picture%2C%20but%20Status%20column%20comes%20all%20in%20red.%3CBR%20%2F%3ECells%20that%20should%20show%20Green%20say%20True%3B%20Cells%20that%20should%20show%20Red%20say%20False%3B%20but%20all%20cells%20come%20out%20in%20Red.%3CBR%20%2F%3E%3CBR%20%2F%3EDue%20Date%20Date%20Received%20Status%3CBR%20%2F%3E8%2F23%2F21%208%2F24%2F21%3CBR%20%2F%3E8%2F19%2F21%208%2F17%2F21%3CBR%20%2F%3E8%2F22%2F21%20FALSE%3CBR%20%2F%3E8%2F23%2F21%208%2F23%2F21%3CBR%20%2F%3E8%2F28%2F21%20FALSE%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2635251%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Drop-Down%20%26amp%3B%20If%20Statements%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2635251%22%20slang%3D%22en-US%22%3EI%20could%20send%20the%20picture%20of%20the%20Conditional%20Formatting%20and%20the%20results%20to%20your%20email%20if%20possible.%3CBR%20%2F%3ERegards%20-%3C%2FLINGO-BODY%3E
Occasional Contributor

I am new in this community -

On the attached spreadsheet:

1 - Scope Drop-down, want more choices, it gives me only one.

2 - Want cell color under Status to turn Red if Date Received is Blank, and turn Green if date is filled. 

Regards -

8 Replies

@BigBolbol 

Hello! You've posted your question in the Tech Community Discussion space, which is intended for discussion around the Tech Community website itself, not product questions. I'm moving your question to the Excel space - please post Excel questions here in the future. 

 

@BigBolbol 

1) Multiple selection from drop-down list that's with VBA programming, the sample is here Excel Data Validation Drop Down Select Multiple Items (contextures.com)

 

2) Since there are only two options with color, you color range in red first and after that apply conditional formatting rule as

image.png

Hi Sergai,
Thanks for your response.
I followed the steps. Unable to attach picture, but Status column comes all in red.
Cells that should show Green say True; Cells that should show Red say False; but all cells come out in Red.

Due Date Date Received Status
8/23/21 8/24/21
8/19/21 8/17/21
8/22/21 FALSE
8/23/21 8/23/21
8/28/21 FALSE

I could send the picture of the Conditional Formatting and the results to your email if possible.
Regards -
best response confirmed by BigBolbol (Occasional Contributor)
Solution

@BigBolbol 

Please check in attached file.

Perfect - It works fine; thanks -
Question: How can I attach file to reply?
I try many ways and couldn't.
Hi Sergei,
I did copy / paste your formula from subject spreadsheet to another one. The formula in the original spreadsheet works perfect. For some reason the formula does not work in another spreadsheet. What is wrong?
I type the formula carefully to make sure proper cells are referenced, but results are negative.
Another concern is that, when I copy / paste formula from a cell in the original spreadsheet, onto the lower cells, the formula works; however the formula does not show in the URL address ribbon.
Please advise.
Hi Sergei,
I did copy / paste your formula from subject spreadsheet to another one. The formula in the original spreadsheet works perfect. For some reason the formula does not work in another spreadsheet. What is wrong?
I type the formula carefully to make sure proper cells are referenced, but results are negative.
Another concern is that, when I copy / paste formula from a cell in the original spreadsheet, onto the lower cells, the formula works; however the formula does not show in the URL address ribbon.
Please advise.