Highlight cells based on drop down selection

**cbetsinger** · 11-02-2017, 07:01 PM

In my sheet (see attachment), how would I set the drop down in status to highlight everything to the left? Please explain it to me so I can understand what was done as I may learn from your help.

What I want to accomplish is when I select "done" for instance, the cells to the left of status are highlighted = Theme Color 7th from the left, its a gray.

**cbetsinger** · 11-02-2017, 09:23 PM

Figured it out with help menu after 3 days.

Conditional Formatting, copy and past the cells...

=$H2="DONE"

Highlight cells based on drop down selection

LinkBack

Thread Tools

Rate This Thread

Display

Highlight cells based on drop down selection

Re: Highlight cells based on drop down selection

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Highlight cells based on dropdown selection

[SOLVED] Colored cells based on drop-down selection

Disable Excel Cells based on Drop-Down Selection.

[SOLVED] Populate a group of cells below Drop Down Menu based on Drop Down Selection

Populate cells based on the selection from a drop down box

Filling Cells Based on Drop Down Selection

Coloring cells based on drop down selection

Bookmarks

Bookmarks

Posting Permissions