Quick Question...

[PaulF]

Normally when I click in the formula bar at the end of an existing formula in a cell, I cell see (assuming they are in my viewable work area) all of the cells involved and they are color coded and matching with the formula...

In one spreadsheet, they color highlight for a split second then go off :-( I hopw this is an easy fix...

Help please...

Respectfully,
PaulF

 

[rrocker1405]

Hi Paul,

If the formula is missing parenthesis this happens. could you verify if the formula is not missing parenthesis? you could also share the spreadsheet as an example after sanitizing it.

Kind regards,
A!

 

[PaulF]

I hope this explains is better... I click at the end of a formula... You get colors in the formula and the cells in the formula... I get them for a nano second, they they go away...