To be clear, David Ackroyd, are you really saying that you managed to change the format of the text in your Excel Formula Bar, or did I misunderstand?
To those who think me pedantic, I protest I'm merely seeking clarity. I'm trying to distinguish between changing the format of the text displayed in the Formula Bar, which is my goal, and using the Formula Bar to change the format of text displayed by a Cell, which is a very different thing…
Did you manage to change the display format of what was shown in the Formula Bar, did it matter what was selected? Individual Cells, manually selected Ranges, Named Ranges or Address Boxes or any other option?
Will you say how exactly you set 'it…' to a specific Font and size (eg Calibri...10)? What 'it…' was selected when you did that? Was the Formula Bar merely showing, because a Cell Range was selected, or was it active because it had been Clicked in?
How sure are you about the circumstances in which 'it…' switches for both the formula bar and named range address box.