Pinterest Pixel

Conditionally Formatting A Drop Down List

In a previous post I showed you how to Create a Drop Down List in a Table. ... read more

Download Excel Workbook
John Michaloudis
Posted on

Steps To Follow

Overview

Conditionally Formatting A Drop Down List | MyExcelOnline Conditionally Formatting A Drop Down List | MyExcelOnline

In a previous post I showed you how to Create a Drop Down List in a Table.   We are now going to take this concept one level further and apply some conditional formatting to the drop down data validation list.

This is useful if you want to highlight when a job is completed, check off items from a list or to evaluate risk in a project just like I have done in below´s example.

Want to know all about Conditional Formatting from Beginner to Advanced?

*** Watch our video and step by step guide below with free downloadable Excel workbook to practice ***

Watch it on YouTube and give it a thumbs-up!

download the youtube excel practice fileConditional-Formatting.xlsx

 

download excel workbook Data-Validation-Conditional-Formatting.xlsx

STEP 1: Select the range that you want to apply the conditional formatting to.

See also  Unlocking the Power of AutoRestore in Excel: A Comprehensive Guide

Conditionally Formatting A Drop Down List

 

STEP 2: Go to Home > Styles > Conditional Formatting > Manage Rules

Conditionally Formatting A Drop Down List

STEP 3: Select New Rule

Conditionally Formatting A Drop Down List

STEP 4: Create the new rule for High values:

Select Use a formula to determine which cells to format

Type in the Formula =$A4=”high” 

This formula will ensure only the column is absolute.

Go to Format > Fill then select a color of your choosing. Click OK.

Conditionally Formatting A Drop Down List

Repeat the same steps for medium values. Click New Rule.

Select Use a formula to determine which cells to format

Type in the Formula =$A4=”medium” 

This formula will ensure only the column is absolute.

Go to Format > Fill then select a color of your choosing. Click OK.

Conditionally Formatting A Drop Down List

Repeat the same steps for low values. Click New Rule.

Select Use a formula to determine which cells to format

Type in the Formula =$A4=”low” 

This formula will ensure only the column is absolute.

Go to Format > Fill then select a color of your choosing. Click OK.

See also  Rank Smallest to Largest With Excel Pivot Tables

Conditionally Formatting A Drop Down List

This is how our new set of rules will look like:

Conditionally Formatting A Drop Down List

Now our table now has conditional formatting applied!

Conditionally Formatting A Drop Down List

Further Learning:

Helpful Resource:

To learn how to add a drop down menu in your Excel Table, click here.

Resize All Charts Using Macros In Excel

 

 

If you like this Excel tip, please share it
Conditionally Formatting A Drop Down List | MyExcelOnline Conditionally Formatting A Drop Down List | MyExcelOnline

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!

Share to...