Formatting font with concantenated string
If it's a once-off, just select the Q1 part in the formula bar, and change
the font colour to blue.
--
HTH
-------
Bob Phillips
... looking out across Poole Harbour to the Purbecks
"Todd" wrote in message
...
Hi,
I'm new to the visual basic world so please bare with
me. I have the following string:
="If Q1 revenue is equal to "&TEXT(A10,"$#,##0")&" then
everything is on track for fiscal 2004."
I would like to able to keep everything as is and change
only "Q1" to bold, blue font.
Any suggestions?
Thanks very much,
Todd
|