Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Color Outline of Formula Cells
I have a bit of a dilema. You know how when you double click on a formula, it
will outline the cells involved in different colors? Well, I have a formula, that when I double click, it will not outline the cells in color. I have tried everything. Is there an option that I need to turn on that I am missing? This workbook came from someone else and I do not know how to get this particular function to work. Any ideas or instruction would be greatly appreciated. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Color Outline of Formula Cells
sounds like the cell might be protected.
check tools-protection-and see if the sheet is protected. if so, it depends on whether the author used a password to protect. "Lost in Excel" wrote: I have a bit of a dilema. You know how when you double click on a formula, it will outline the cells involved in different colors? Well, I have a formula, that when I double click, it will not outline the cells in color. I have tried everything. Is there an option that I need to turn on that I am missing? This workbook came from someone else and I do not know how to get this particular function to work. Any ideas or instruction would be greatly appreciated. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Color Outline of Formula Cells
Sorry "bj" sheet was not protected. Thanks though. Anyone else?
"bj" wrote: sounds like the cell might be protected. check tools-protection-and see if the sheet is protected. if so, it depends on whether the author used a password to protect. "Lost in Excel" wrote: I have a bit of a dilema. You know how when you double click on a formula, it will outline the cells involved in different colors? Well, I have a formula, that when I double click, it will not outline the cells in color. I have tried everything. Is there an option that I need to turn on that I am missing? This workbook came from someone else and I do not know how to get this particular function to work. Any ideas or instruction would be greatly appreciated. Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Color Outline of Formula Cells
Actually rereading the question it is definately not protected. it is acting
as text instead of a formula. check the format in format cell number and see if it is text. change if it is. then select the equal sign and replace with another equal sign this will often change text to a formula "Lost in Excel" wrote: Sorry "bj" sheet was not protected. Thanks though. Anyone else? "bj" wrote: sounds like the cell might be protected. check tools-protection-and see if the sheet is protected. if so, it depends on whether the author used a password to protect. "Lost in Excel" wrote: I have a bit of a dilema. You know how when you double click on a formula, it will outline the cells involved in different colors? Well, I have a formula, that when I double click, it will not outline the cells in color. I have tried everything. Is there an option that I need to turn on that I am missing? This workbook came from someone else and I do not know how to get this particular function to work. Any ideas or instruction would be greatly appreciated. Thanks |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Color Outline of Formula Cells
Maybe ranges are on ohter sheet. Example: Formula on sheet1 and references on
sheet2 "bj" wrote: Actually rereading the question it is definately not protected. it is acting as text instead of a formula. check the format in format cell number and see if it is text. change if it is. then select the equal sign and replace with another equal sign this will often change text to a formula "Lost in Excel" wrote: Sorry "bj" sheet was not protected. Thanks though. Anyone else? "bj" wrote: sounds like the cell might be protected. check tools-protection-and see if the sheet is protected. if so, it depends on whether the author used a password to protect. "Lost in Excel" wrote: I have a bit of a dilema. You know how when you double click on a formula, it will outline the cells involved in different colors? Well, I have a formula, that when I double click, it will not outline the cells in color. I have tried everything. Is there an option that I need to turn on that I am missing? This workbook came from someone else and I do not know how to get this particular function to work. Any ideas or instruction would be greatly appreciated. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I want my cells to stop appearing in an outline format | Excel Discussion (Misc queries) | |||
How to change the active cell outline indicator color in Excel? | Excel Discussion (Misc queries) | |||
Outline color of cell that has focus | Excel Discussion (Misc queries) | |||
Can I outline in color only the active cell? | Excel Discussion (Misc queries) | |||
Adding formatted cells to an outline ? | Excel Discussion (Misc queries) |