Struggling with this one. In-line Cell formatting again

NoSparks · #1 02-16-2017, 09:26 AM

That's interesting...

What shows at the bottom of the drop down isn't blank,
what shows in the formula bar is the single quote
doing a len() calculation of the cell gives zero
and running this little code I use to see what's actually in a cell returns nothing

Code:

Sub CheckOfCharacters()
    Dim i As Integer
    Dim str As String

str = ActiveCell.Value

    For i = 1 To Len(str)
        Debug.Print Mid(str, i, 1) & "  =  " & Asc(Mid(str, i, 1))
    Next

End Sub

I guess the work around would be to put your list into a column somewhere and in the validation for the list specify the range plus the cell on the next row which would be empty.

TJMorgan · #2 02-16-2017, 10:02 AM

Okay - see where you're going. However, ignore the highlighted cell on the screen grab - my error. The cell on the right of it - above the two figures, is the one I want to format to change the text colour to grey in A32. No figures in D32 - text grey on A32. Figures in D32, text returns to black in A32. There must be a way to do it - I just can't see it!

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formatting unprotected cell in protected w/s makes the cell locked?	tango356	Excel	2	01-23-2017 02:13 PM
Pasting text from Excel cell into word without creating a table, and keeping the in-cell formatting	hanvyj	Excel Programming	0	08-28-2015 01:15 AM
Question re: Conditional formatting (cell occurs after another cell)	Saywarder	Excel	1	04-20-2015 11:29 AM
Conditional Cell Formatting: Alternating Cell Checks	corbott	Excel	4	12-16-2014 01:51 PM
How can I fill cell color starting from Cell D5 using Conditional formatting instead	Learner7	Excel	0	07-08-2010 05:50 AM