Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formula Color Coding
Usually, when I edit a cell (F2) that contains a formula, the cells the
formula calculates are color coded and a border appears around each cell in their own color. Now, when I edit, everything is just black and white (no color coding). Any ideas? |
#2
|
|||
|
|||
What version of excel are you using when it doesn't work?
And are you saying that the outlines show up, but they're all black or they don't show up at all (maybe you see gridlines or borders)? Andrew wrote: Usually, when I edit a cell (F2) that contains a formula, the cells the formula calculates are color coded and a border appears around each cell in their own color. Now, when I edit, everything is just black and white (no color coding). Any ideas? -- Dave Peterson |
#3
|
|||
|
|||
Excel 2000.
The outlines don't show up at all... "Dave Peterson" wrote: What version of excel are you using when it doesn't work? And are you saying that the outlines show up, but they're all black or they don't show up at all (maybe you see gridlines or borders)? Andrew wrote: Usually, when I edit a cell (F2) that contains a formula, the cells the formula calculates are color coded and a border appears around each cell in their own color. Now, when I edit, everything is just black and white (no color coding). Any ideas? -- Dave Peterson |
#4
|
|||
|
|||
I know that they were there with xl2002. I don't recall if they were there in
xl2k. (Bad memory!) Maybe someone using xl2k can chime in. (I was kind of hoping you were using two different versions--and the newer version had this feature. But that was just a selfish guess!) Andrew wrote: Excel 2000. The outlines don't show up at all... "Dave Peterson" wrote: What version of excel are you using when it doesn't work? And are you saying that the outlines show up, but they're all black or they don't show up at all (maybe you see gridlines or borders)? Andrew wrote: Usually, when I edit a cell (F2) that contains a formula, the cells the formula calculates are color coded and a border appears around each cell in their own color. Now, when I edit, everything is just black and white (no color coding). Any ideas? -- Dave Peterson -- Dave Peterson |
#5
|
|||
|
|||
The color coding outlines do appear in Excel 2000 as well...
"Dave Peterson" wrote: I know that they were there with xl2002. I don't recall if they were there in xl2k. (Bad memory!) Maybe someone using xl2k can chime in. (I was kind of hoping you were using two different versions--and the newer version had this feature. But that was just a selfish guess!) Andrew wrote: Excel 2000. The outlines don't show up at all... "Dave Peterson" wrote: What version of excel are you using when it doesn't work? And are you saying that the outlines show up, but they're all black or they don't show up at all (maybe you see gridlines or borders)? Andrew wrote: Usually, when I edit a cell (F2) that contains a formula, the cells the formula calculates are color coded and a border appears around each cell in their own color. Now, when I edit, everything is just black and white (no color coding). Any ideas? -- Dave Peterson -- Dave Peterson |
#6
|
|||
|
|||
Thanks for jumping in. Have you ever seen them disappear. (I don't think I've
ever seen them go away.) Andrew wrote: The color coding outlines do appear in Excel 2000 as well... "Dave Peterson" wrote: I know that they were there with xl2002. I don't recall if they were there in xl2k. (Bad memory!) Maybe someone using xl2k can chime in. (I was kind of hoping you were using two different versions--and the newer version had this feature. But that was just a selfish guess!) Andrew wrote: Excel 2000. The outlines don't show up at all... "Dave Peterson" wrote: What version of excel are you using when it doesn't work? And are you saying that the outlines show up, but they're all black or they don't show up at all (maybe you see gridlines or borders)? Andrew wrote: Usually, when I edit a cell (F2) that contains a formula, the cells the formula calculates are color coded and a border appears around each cell in their own color. Now, when I edit, everything is just black and white (no color coding). Any ideas? -- Dave Peterson -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions |