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?