| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
How do I keep the format of a cell that an if statment refers to?
I'm using an if statemnt and the result if true points to one cell with
special formats and another cell if false with other formats. The result shows the correct value, but I'm more interested in the font because I'm using different symbols from various fonts. |
|
#2
|
|||
|
|||
|
Formulas return values--not formats.
Maybe you could use some other way--like a worksheet event that actually does a copy|paste??? Gerardo wrote: I'm using an if statemnt and the result if true points to one cell with special formats and another cell if false with other formats. The result shows the correct value, but I'm more interested in the font because I'm using different symbols from various fonts. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy a cell (content AND format) from one worksheet to a. | Excel Worksheet Functions | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Discussion (Misc queries) | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
| How do I unhide the cell format function in Excel 2000 | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Hybrid Mode
