Solved Conditional formatting of cells in multiple sheets

September 6, 2013 at 10:38:15
Specs: Windows XP
I have twelve sheets that each have a total score on cell G10 that I want to have copied to a thirteenth sheet in a specific column (F5-16). What would I have to do to make that happen? The G10 cell is an auto-summed cell, if that makes a difference.

Also, is there a specific way to create formulas? It seems like everyone's so super smart, just figuring this stuff out! It's awesome!


See More: Conditional formatting of cells in multiple sheets

Report •


✔ Best Answer
September 6, 2013 at 15:53:47
=, clicking sheet A G10 and pressing Enter

That's the easiest way.

MIKE

http://www.skeptic.com/



#1
September 6, 2013 at 13:56:54
I'm sorry I have no idea what you want.

Your heading speaks of Conditional Formatting,
while your post seems to imply you want to copy one cell, G10
to a range of cells, F5 thru F16.

After reading this how to:
http://www.computing.net/howtos/sho...

Post an example of what your looking to do.

MIKE

http://www.skeptic.com/


Report •

#2
September 6, 2013 at 14:20:05
Name/	     Total Score               Location (in 
sheet           (G10)                  sheet M)  

A	         173	                 F5
B	         164	                 F6
C	         178	                 F7
D	         182	                 F8
E	         191	                 F9
F	         190	                 F10
G	         187	                 F11
H	         162	                 F12
I	         171	                 F13
J	         169	                 F14
K	         172	                 F15
L	         184	                 F16

I was told that this could be done by applying a rule to the data in sheets A-L to have each individual G10 value show on sheet M. Is this possible, or would I just have to go and just link each value from each sheet into my row on sheet M?

message edited by stand.lauren


Report •

#3
September 6, 2013 at 14:48:29
OK, if I understand you correctly,

You have 12 sheets labeled A thru L
each sheet has a Total Score in cell G10
You want to display all 12 Total Scores in sheet M
beginning at cell F5 thru F16

So on Sheet M, cell F5 you would enter a formula like:

=SheetA!G10

In effect, your saying, Sheet M Cell F5 equals the value found in Cell G10 of Sheet A

So if the total in cell G10 on Sheet A changes,
it is automatically reflected on Sheet M, cell F5

Simply changing the Sheet letter in the above formula,
for the rest of column F should get you what you want.

Sheet M cell F6 would be: =SheetB!G10
Sheet M cell F7 would be: =SheetC!G10
etc. etc.

MIKE

http://www.skeptic.com/


Report •

Related Solutions

#4
September 6, 2013 at 15:06:23
Is that the same as linking? That sounds like it works! I've made it work so far by doing this:

F5: =, clicking sheet A G10 and pressing Enter

And I just do this for each sheet, in each F cell.

message edited by stand.lauren


Report •

#5
September 6, 2013 at 15:53:47
✔ Best Answer
=, clicking sheet A G10 and pressing Enter

That's the easiest way.

MIKE

http://www.skeptic.com/


Report •


Ask Question