highlighted cells

cpc · May 16th, 2002, 08:59 PM

Iam using excel xp. When I double click a cell that contains a formula, the cells used in the formula are highlighted with a colored border. I seem to have one rouge cell. When I double click on this particular cell, the cells used in the formula are not highlighted. Why is this for this one cell and is there a way to turn this feature on and off? Per cell? Thanks.

cpc · May 16th, 2002, 10:53 PM

I have been playing with this problem, and if I delete cells in the formula to a certain point the highlighting appears. It seems to be at 34 computations.(=a2+a42+a82 etc till 34 additions) Is there a limit to this feature of highlighting cells?

Yogi Anand · May 16th, 2002, 11:29 PM

Quote:

On 2002-05-16 21:53, cpc wrote:
I have been playing with this problem, and if I delete cells in the formula to a certain point the highlighting appears. It seems to be at 34 computations.(=a2+a42+a82 etc till 34 additions) Is there a limit to this feature of highlighting cells?

I believe there is a limit of 30 as to the number of arguments in most functions.

Regards!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 16th, 2002, 08:59 PM	#1
cpc New Member Join Date: Mar 2002 Posts: 38	Iam using excel xp. When I double click a cell that contains a formula, the cells used in the formula are highlighted with a colored border. I seem to have one rouge cell. When I double click on this particular cell, the cells used in the formula are not highlighted. Why is this for this one cell and is there a way to turn this feature on and off? Per cell? Thanks.

May 16th, 2002, 10:53 PM	#2
cpc New Member Join Date: Mar 2002 Posts: 38	I have been playing with this problem, and if I delete cells in the formula to a certain point the highlighting appears. It seems to be at 34 computations.(=a2+a42+a82 etc till 34 additions) Is there a limit to this feature of highlighting cells?