Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #8  
Old 04-04-2017, 02:27 PM
Aussie_81 Aussie_81 is offline Have a cell filled black when blank in dropdown list Windows 10 Have a cell filled black when blank in dropdown list Office 2016
Novice
Have a cell filled black when blank in dropdown list
 
Join Date: Apr 2017
Posts: 7
Aussie_81 is on a distinguished road
Default

Here is the spreadsheet I was referring to.

Note: When in the spreadsheet "STN1" and on row 15, column B, if the user selects the very last value from the dropdown list (under STN4) the population is blank rather than black.

The sheet "Data List" is where I have the formulas pertaining the "STN1" sheet
Attached Files
File Type: xlsx Example.xlsx (19.8 KB, 9 views)
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Have a cell filled black when blank in dropdown list Formulato say if cell is blank do this, if not blank do this. mbesspiata Excel 1 01-17-2015 05:02 AM
Have a cell filled black when blank in dropdown list Using word art in a table with a filled cell halfnite Word 5 10-07-2014 05:24 PM
Auto add a list cell if the last list cell is filled tasuooooo Excel 1 07-31-2012 08:40 PM
Change cell color everytime a value is selected in dropdown list angelica_gloria Excel 4 01-27-2012 06:47 PM
Forms: combination of a list and a text field to be filled in bart014 Word 0 04-23-2010 12:55 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:05 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft