Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I create multiple formats of text in a formula?
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I create multiple formats of text in a formula?
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 "bvandame7766" wrote: 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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I create multiple formats of text in a formula?
On Mon, 17 Sep 2007 19:14:00 -0700, bvandame7766
wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i use multiple cells to create a formula ? | Excel Discussion (Misc queries) | |||
Using formula to create multiple versions of a Graphs | Charts and Charting in Excel | |||
How do I create a formula for multiple levels of discounts? | Excel Worksheet Functions | |||
how to create a multiple conditional formula | Excel Discussion (Misc queries) | |||
How to create a formula with multiple contraints and answers | Excel Discussion (Misc queries) |