Formula Color Coding

A

Andrew

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?
 
D

Dave Peterson

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)?
 
D

Dave Peterson

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!)
 
D

Dave Peterson

Thanks for jumping in. Have you ever seen them disappear. (I don't think I've
ever seen them go away.)
The color coding outlines do appear in Excel 2000 as well...
Click to expand...
 

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

Font is changing when editing a cell 0
F2 - NO color-coded precedents??? 2
how to format cells -fill color 2
Conditional format color change 2
Limit of color-coded cell references editing a formula. 1
Real-Time Co-Authoring stops working 0
Change the black selected-cell-border to another color (cursor) 0
Cell fill color in linked cells? 1

Top