| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
My formula's answer is calculated, but disappears
I have an excel document here where I have the same formula in a column of
boxes. 2 of these boxes look blank, but when highlighted you can see the answer - but only highlighted. How do I fix this? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
My formula's answer is calculated, but disappears
Try changing the text color for those cells. Chances are that the text
color is the same color as the cell background. "Niki" wrote in message ... I have an excel document here where I have the same formula in a column of boxes. 2 of these boxes look blank, but when highlighted you can see the answer - but only highlighted. How do I fix this? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
My formula's answer is calculated, but disappears
I did try that, it didn't work. Messing with the font doesn't change it.
"PCLIVE" wrote: Try changing the text color for those cells. Chances are that the text color is the same color as the cell background. "Niki" wrote in message ... I have an excel document here where I have the same formula in a column of boxes. 2 of these boxes look blank, but when highlighted you can see the answer - but only highlighted. How do I fix this? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
My formula's answer is calculated, but disappears
Maybe the cell has conditional formatting applied to it.
"Niki" wrote in message ... I did try that, it didn't work. Messing with the font doesn't change it. "PCLIVE" wrote: Try changing the text color for those cells. Chances are that the text color is the same color as the cell background. "Niki" wrote in message ... I have an excel document here where I have the same formula in a column of boxes. 2 of these boxes look blank, but when highlighted you can see the answer - but only highlighted. How do I fix this? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
My formula's answer is calculated, but disappears
YES! Thank you!
"PCLIVE" wrote: Maybe the cell has conditional formatting applied to it. "Niki" wrote in message ... I did try that, it didn't work. Messing with the font doesn't change it. "PCLIVE" wrote: Try changing the text color for those cells. Chances are that the text color is the same color as the cell background. "Niki" wrote in message ... I have an excel document here where I have the same formula in a column of boxes. 2 of these boxes look blank, but when highlighted you can see the answer - but only highlighted. How do I fix this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formulas not recognizing new data | Excel Discussion (Misc queries) | |||
| Problem with named formula's | Excel Worksheet Functions | |||
| Formulas | Excel Worksheet Functions | |||
| Dynamic Formulas with Dynamic Ranges | Excel Worksheet Functions | |||
| calculating formulas for all workbooks in a folder | Excel Worksheet Functions | |||
Linear Mode
