Thread: Have a cell filled black when blank in dropdown list
View Single Post
 
Old 04-01-2017, 09:06 PM
Aussie_81 Aussie_81 is offline Windows 10 Office 2016
Novice
  
Join Date: Apr 2017
Posts: 7
Aussie_81 is on a distinguished road
Default
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?
Reply With Quote