Need to auto-populate cells "N/A" when selecting from a drop-down list.

**CAABYYC** · 01-08-2016, 04:46 PM

please see the test file in attach.

It doesn't show you "N/A" but only uses "black out" indication in designated cells with conditional format (no formula used)

**dpeek** · 01-12-2016, 05:25 PM

I see you used conditional formatting. I haven't thought to use it that way. Thanks a bunch for your assistance. This should solve my issues.

Need to auto-populate cells "N/A" when selecting from a drop-down list.

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Re: Need to auto-populate cells "N/A" when selecting from a drop-down list.

Re: Need to auto-populate cells "N/A" when selecting from a drop-down list.

Thread Information

Users Browsing this Thread

Similar Threads

Is it possible to reverse the order in a cells "Drop Down List"?

[SOLVED] Auto-populate "Yes" "No" based on multiple criteria.

Cmd Button to populate all drop down list on a worksheet as "Yes"

Solution to populate cell with "X" by selecting "R"

Manipulate data presentation using "Drop down list" and "Filter"

Getting "like named" products to populate from drop down list

[SOLVED] "Create a drop-down list from a range of cells"

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions