Share via

DATA VALIDATION (LIST)/ COLOR

Anonymous
2018-10-01T14:37:55+00:00

I believe this is simple. I have a workbook with many drop down lists from many data lists (all different). I want excel to either change the color of a cell to RED when nothing is selected to alert the user that they must choose from the list OR some other option I can think of. Can someone help me out? Thank you.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2018-10-01T14:53:27+00:00

    To make sure something is selected in Data Validation make sure Ignore Blank (Data Validation > Settings) is NOT checked.

    To make blank cells red:

    1. Select all cells that must not be blank.
    2. Use Home (tab) > Conditional Formatting (icon) > New Rule
    3. Select Format only cells that contain
    4. In Format only Cells with: select Blanks
    5. Set format to red fill.

    10+ people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-10-01T16:16:17+00:00

    Thank you. #rockstar

    1 person found this answer helpful.
    0 comments