|
|
#3
04-01-2017, 09:06 PM
|
|||
|
|||
I have done as described and the dropdown list still only has a blank cell and not a black filled cell.
I can't attach an image for you to see as it appears the forum only allows http links. The "Conditional Formatting Rule Manager" has: Formula: ="LEN(B*)=0" Format: is a black block Applies to: =$B$8 The dropdown list values are in one sheet and the sheet that uses the dropdown list that the values are referenced are in another if that is of any relevance? 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Formulato say if cell is blank do this, if not blank do this.
|
mbesspiata | Excel | 1 | 01-17-2015 05:02 AM |
|
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 |
Windows 10 
Office 2016
Threaded Mode