Aug 08 2021 12:01 PM
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 -
Aug 09 2021 09:58 AM
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.
Aug 09 2021 12:38 PM
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
Aug 11 2021 01:50 AM
Aug 11 2021 01:55 AM
Aug 11 2021 08:27 AM
SolutionPlease check in attached file.
Aug 11 2021 03:02 PM
Aug 11 2021 07:46 PM
Aug 11 2021 07:48 PM
Aug 11 2021 08:27 AM
Solution