cells

[Learner]

Hello, I used to click a cell that contain a formula like =b1+b2+b3 etc and
then see all of those cells in various colour. It was easy to locate them
now today, none of these cells are coloured. Any suggestion?

Office 2003 xp sp2.

Thanks

 

[Otto Moehrbach]

I have never seen what you describe. If you select the cell and then click
in the formula bar, you will get what you describe. HTH Otto

 

[Gord Dibben]

Do you have Tools>Options>Edit>Edit directly in cell checked?

If so, you should be able to double-click the cell and see your colors.

A single click has never shown colors.


Gord Dibben MS Excel MVP

 

[Learner]

there is a limit in the number of characters 133 or something like that I
forgot the number. Pass that the colors disappear. Is there a way to
extend that number?

 

[Gord Dibben]

30 arguments is the limit.

Past that you won't see the colors.

Depending upon what formula or function you are using, there may be
workarounds.

e.g.

=SUM(30 non-contiguous cells) is the limit.

=SUM((many non-contiguous cells)) will extend.

I tested to 90 cells and ran out of patience.


Gord