Forum Discussion
Excel - Drop-Down & If Statements
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 -
Please check in attached file.
8 Replies
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
- I could send the picture of the Conditional Formatting and the results to your email if possible.
Regards -Please check in attached file.
- 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
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.
