Have a cell filled black when blank in dropdown list

jeffreybrown · #1 04-01-2017, 07:08 PM

Hello & Welcome to the Forum,

You can use CF...

Conditional Formatting

Highlight applicable range >> A1
Home Tab >> Styles >> Conditional Formatting >> New Rule
Select a Rule Type: Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true: =LEN(A1)=0
Format… [Number, Font, Border, Fill]
OK >> OK

Aussie_81 · #2 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?

jeffreybrown · #3 04-02-2017, 06:35 AM

Quote:

Formula: ="LEN(B*)=0"

Not sure what's going on with your formula as it should be =LEN(B8)=0 and no quotes

From the FAQ...

Quote:

To attach a file to a new post, simply click the [click Go advanced - Manage attachments] button at the bottom of the post composition page, and locate the file that you want to attach from your local hard drive.

Aussie_81 · #4 04-03-2017, 12:33 AM

Please see below

Aussie_81 · #5 04-03-2017, 12:36 AM

Thanks Jeffrey Brown,

I used the apostrophises to represent the exact value stated, however I didn't check the post as I must have pressed shift 8 instead of just 8.

Please see the attached images (thanks for that).

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