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
Formula Color Coding 5
hit F2, want the color coded formula to appear in formula bar not 1
Double clicking formula cell doesn't highlight precedent cells 0
formatting color of destination cells 1
Using F2 to edit a cell 5
How do I only calculate cells which have a filled color format? 1

Top