Just to show what I am trying to do here, I have added a screen grab (I hope). When D32 is empty (it's the figures column, as B32/C32 are joined), I would like the text in A32 (Filter) to become grey (ghost text). If figures are then added back into D32, the text in A32 returns to black. Hope that makes sense.