Highlighted cells

[layout]

I am adding a string of several cells. When I would cick on the cell
had my forumula in it would put a color highlight around each cel
that was used in my formula. It is about 50 + cells now and when
click in the formula cell nothing is highlighted . How do I get th
cells in my formula to be highlighted when i click in the cell with m
formula? thank

 

[Gord Dibben]

Excel has a 30 argument limit.

Once you pass the 30 cells the color highlighting ceases to be.


Gord Dibben MS Excel MVP