Monday, August 18, 2014

Create a drop-down list with color - Microsoft Excel in Mac



  1. On a new worksheet, type the values that you want to appear in your drop-down list. They should be in a single column or row without any blank cells (for easy to use, it is recommended to sort your values).
  2. Select all of your values, right-click, and then click "Define Name"
  3. Then it will prompt up a "New Name" window. Type a name for the values of your drop-down list and then click "OK". (No space in the name. )
  4. Select the cells that you want to have drop-down list.
  5. Click Data Validation.
  6. In the settings tab, select "List" from Allow box
  7. From the source field, type equal sign (=) and immediately followed by the name you defined in step 3.
  8. Click OK to confirm.
Apply the Conditional Formatting to color coded the drop-down list values.

  1. Highlight the cells you want to have drop-down list.
  2. Then click "Conditional Formatting" --> New Rule.
  3. Select "format only cells that contain"
  4. Edit your condition in the session called "Edit the Rule Description".
  5. Click "format" button to select your desired color in cell.

No comments:

Post a Comment