Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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??? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I add cells by highlighting them? | Excel Discussion (Misc queries) | |||
Highlighting cells | Excel Worksheet Functions | |||
highlighting cells | Excel Discussion (Misc queries) | |||
HIGHLIGHTING CELLS | Excel Discussion (Misc queries) | |||
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) |