Click here for important information about

Color code data validation lists?

Microsoft Excel 2010
August 18, 2011 at 05:56:05
Specs: Windows Explorer
In Excel when creating a column with a dropdown list - in data validation - can you add a fill color to go with certain text? My example is "status" of a line item. Being In Review, Not Started, In Process, etc. I'd like to have a certain color go with each separate do I do this?

See More: Color code data validation lists?

August 19, 2011 at 18:57:57
You can use Conditional Formatting to fill the cell with a color based on the contents.

Home Ribbon...Conditional Formatting...New Rule

Format only cells that contain...Cell Value...Equal to...In Review

Click Format and choose a format.

Repeat as required.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •
Related Solutions

Ask Question