Can I create multiple formats of text in a formula?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bvandame7766 - 18 Sep 2007 03:14 GMT

I'm trying to set up an "if" statement that says if a cell equals "no" to
enter a question in regular text and then display the possible answers in
bolded text right afterwards. I think I remember seeing it somewhere, but I
can't remember how to do it or if I'm thinking of another program.

Reply to this Message

FSt1 - 18 Sep 2007 03:36 GMT

hi,
if i understand you correctly, no.
you can have multiple formats in a cell but not with a formula. multiple
formats require exact start and stop points within the cell and a formula may
return varing lengths of numbers/text depending. also vb reads the contents
of the cell to decide multiple formats and what is in the cell is a formula
which may not have the same number of characters in the results that the
formula returns.
so i would guess that your are thinking of another program. wild guess.

sorry.
FSt1

> I'm trying to set up an "if" statement that says if a cell equals "no" to
> enter a question in regular text and then display the possible answers in
> bolded text right afterwards. I think I remember seeing it somewhere, but I
> can't remember how to do it or if I'm thinking of another program.

Reply to this Message

Ron Rosenfeld - 18 Sep 2007 04:19 GMT

>I'm trying to set up an "if" statement that says if a cell equals "no" to
>enter a question in regular text and then display the possible answers in
>bolded text right afterwards. I think I remember seeing it somewhere, but I
>can't remember how to do it or if I'm thinking of another program.

You can't do that with a worksheet formula. You would need to use a Visual
Basic routine to generate your text string, and differentially format the
contents of the cell.

You could Bold the entire contents of a cell or cells using Conditional
Formatting. So you could (if I understand you correctly) have A1 possibly =
"No". Then you could have your question in B1. C1 would contain the possible
answers and would be "conditionally formatted" to be Bold if A1 = "No".
--ron

Reply to this Message