{"id":319,"date":"2016-04-14T23:55:32","date_gmt":"2016-04-14T21:55:32","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=319"},"modified":"2024-03-22T19:06:53","modified_gmt":"2024-03-22T18:06:53","slug":"conditionally-formatting-a-drop-down-list","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/conditionally-formatting-a-drop-down-list\/","title":{"rendered":"Conditionally Formatting A Drop Down List"},"content":{"rendered":"

In a previous post I showed you how to Create a Drop Down List in a Table<\/span><\/a><\/strong><\/span>.\u00a0 \u00a0We are now going to take this concept one level further and apply some conditional formatting to the drop down data validation list.<\/a><\/p>\n

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\u00b4s example.<\/p>\n

\n
\n

Table of Contents<\/p>\n<\/span><\/div>\n