Thread: Struggling with this one. In-line Cell formatting again
View Single Post
 
Old 02-16-2017, 08:31 AM
TJMorgan TJMorgan is offline Windows 10 Office 2013
Novice
  
Join Date: Feb 2017
Posts: 8
TJMorgan is on a distinguished road
Default
No I haven't tried that. Fairly new to Excel at this level. I tried formating from B20 - then realised it had dropdown text in it. D20 in the same row contains only manual insertion of figures. When empty this would seem the logical cell to format to invoke Conditional Formting in Cell A20. In other words 'If I'm empty change text in Cell A20 to grey.
Reply With Quote