Thread: Struggling with this one. In-line Cell formatting again
View Single Post
 
Old 02-16-2017, 08:39 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
You're still not saying what you've tried.

based on " six items with a blank space at the end (',') "
I'm not quite sure what a blank is, that looks like a comma to me

Conditional formatting (for a blank) would be =ISBLANK(B20)
Reply With Quote