add drop-down menu in Excel & add color

  • Highlight empty cells where the drop down option is wanted.
  • Look on Data tab & click Data Validation. 
  • Under allow: use option LIST
  • Using function for Source, highlight the list of options that you want to use for the list. 

To Add Color

  • Highlight cells within the table that you want color added to. 
  • Click Conditional Formatting and New Rule

  • Using these options, pick the cell you would like to edit:

  • In the Format box, pick fill option and color of choosing (grey here). 


11_23_2016

One thought on “add drop-down menu in Excel & add color

  1. Pingback: add drop-down menu in Excel & add color — Undercutsyou.com – SutoCom Solutions

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s