View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_5_] Bob Phillips[_5_] is offline
external usenet poster
 
Posts: 620
Default 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