Can I create multiple formats of text in a formula?

B

bvandame7766

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.
 
F

FSt1

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
 
R

Ron Rosenfeld

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.
Click to expand...

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
 
Top