Highlighting Cells being used in Calculation

  • Thread starter Thread starter walrus
  • Start date Start date
W

walrus

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???
 
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
 
where exactly is the toolbar?

Gary Brown said:
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
Click to expand...
 
Back
Top