F2 - NO color-coded precedents???

T

TimK

I just got upgraded to Vista and Excel 2003, however one fluke has appeared.

If I reference more than 32 cells within a formula and I hit F2 to edit the
formula, I lose the color-coded precedent function.

Prior to this, all the referenced cells would be color-outlined.
 
G

Gord Dibben

See reply to your other post.

Not necessary to multi-post in these Excel news groups.


Gord Dibben MS Excel MVP
 
B

Bernard Liengme

Have you also noted that when you F2 or double click a cell with a formula
that the red X and green check-mark are not visible in the formula bar; but
they do appear if you let the mouse point hover in place were they live?
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2003 cell references - >32 refs - no more highlighting? 4
Limit of color-coded cell references editing a formula. 1
hit F2, want the color coded formula to appear in formula bar not 1
Formula Color Coding 5
How to restore F2 functions 4
Copy formula where the cell refrence is not sequential 1
Cursor now appearing in formula bar, no longer in cell 2
Create cell reference color coded border with square corners 0

Top