Highlighting Cells being used in Calculation
 

A are the row numbers
B Revenue streams
C Revenue Amounts



A B C

Total
265 P Sales 40,039,874.16
266 Adj (3,314,674.99)
267 SW Sales 7,328,930.75
268 SW Adj 4,443,225.97
269 TP Sales 13,626,743.20
270 TP ADJ (1,047,169.60)
271 Others (12,139,812.20)
272 Others Adj (33,517.04)
273 Suspense 1,686,250.49
274 TOTAL 50,589,850.74
275 Service 363,695.33
276 Service Adj 480,921.08
277 Consultancy 2,076,780.35
278 Consultancy Adj (2,026,051.39)
278 * Net Service Sales 1,044,701.68
278 ** Total Net Sales 51,634,552.42
Sum Formula =C265+C267+C269+C275+C277

How can i highlight cells/rows being used in the sum formula above with
individually selecting them???

Highlighting Cells being used in Calculation
 

If you doulbe-click on the formula cell, it's references will highlight.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"walrus" wrote:

A are the row numbers
B Revenue streams
C Revenue Amounts



A B C

Total
265 P Sales 40,039,874.16
266 Adj (3,314,674.99)
267 SW Sales 7,328,930.75
268 SW Adj 4,443,225.97
269 TP Sales 13,626,743.20
270 TP ADJ (1,047,169.60)
271 Others (12,139,812.20)
272 Others Adj (33,517.04)
273 Suspense 1,686,250.49
274 TOTAL 50,589,850.74
275 Service 363,695.33
276 Service Adj 480,921.08
277 Consultancy 2,076,780.35
278 Consultancy Adj (2,026,051.39)
278 * Net Service Sales 1,044,701.68
278 ** Total Net Sales 51,634,552.42
Sum Formula =C265+C267+C269+C275+C277

How can i highlight cells/rows being used in the sum formula above with
individually selecting them???

Highlighting Cells being used in Calculation
 

After double-clicking to select the cells, if you want, you can then hit the
'Fill Color' button on the 'Formating' toolbar to change the color of those
selected cells.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Gary Brown" wrote:

If you doulbe-click on the formula cell, it's references will highlight.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"walrus" wrote:

A are the row numbers
B Revenue streams
C Revenue Amounts



A B C

Total
265 P Sales 40,039,874.16
266 Adj (3,314,674.99)
267 SW Sales 7,328,930.75
268 SW Adj 4,443,225.97
269 TP Sales 13,626,743.20
270 TP ADJ (1,047,169.60)
271 Others (12,139,812.20)
272 Others Adj (33,517.04)
273 Suspense 1,686,250.49
274 TOTAL 50,589,850.74
275 Service 363,695.33
276 Service Adj 480,921.08
277 Consultancy 2,076,780.35
278 Consultancy Adj (2,026,051.39)
278 * Net Service Sales 1,044,701.68
278 ** Total Net Sales 51,634,552.42
Sum Formula =C265+C267+C269+C275+C277

How can i highlight cells/rows being used in the sum formula above with
individually selecting them???

Highlighting Cells being used in Calculation
 

where exactly is the toolbar?

"Gary Brown" wrote:

After double-clicking to select the cells, if you want, you can then hit the
'Fill Color' button on the 'Formating' toolbar to change the color of those
selected cells.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Gary Brown" wrote:

If you doulbe-click on the formula cell, it's references will highlight.
--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"walrus" wrote:

A are the row numbers
B Revenue streams
C Revenue Amounts



A B C

Total
265 P Sales 40,039,874.16
266 Adj (3,314,674.99)
267 SW Sales 7,328,930.75
268 SW Adj 4,443,225.97
269 TP Sales 13,626,743.20
270 TP ADJ (1,047,169.60)
271 Others (12,139,812.20)
272 Others Adj (33,517.04)
273 Suspense 1,686,250.49
274 TOTAL 50,589,850.74
275 Service 363,695.33
276 Service Adj 480,921.08
277 Consultancy 2,076,780.35
278 Consultancy Adj (2,026,051.39)
278 * Net Service Sales 1,044,701.68
278 ** Total Net Sales 51,634,552.42
Sum Formula =C265+C267+C269+C275+C277

How can i highlight cells/rows being used in the sum formula above with
individually selecting them???