hit F2, want the color coded formula to appear in formula bar not

T

Tiff L

At my previous job when I hit F2 a color coded formula appeared in my formula
bar. Each cell reference is a different colr in the formula and the actual
cells in the worksheet are outlined in its corresponing color. Now at my new
job, the color coded formula appears in the cell. I don't like this
especially because the long formulas usually cover up the what's in adjacent
cells. Is there a a way to switch it back to formula bar display only?
 

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

F2 - NO color-coded precedents??? 2
IF OR AND in same conditional formula 2
Searching the formula (not the value) for a text string 1
Why do I loose color in cells with this string? 2
Formula appearing as Value in Formula Bar 1
How do I add the formula bar? 2
Conditional Formatting Based On Formula Values 2
Excel formula-cell reference not working 3

Top