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

September 6, 2013 at 15:53:47
 =, clicking sheet A G10 and pressing EnterThat's the easiest way.MIKEhttp://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, G10to 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.MIKEhttp://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 Leach sheet has a Total Score in cell G10You want to display all 12 Total Scores in sheet Mbeginning at cell F5 thru F16So on Sheet M, cell F5 you would enter a formula like:=SheetA!G10In effect, your saying, Sheet M Cell F5 equals the value found in Cell G10 of Sheet ASo if the total in cell G10 on Sheet A changes, it is automatically reflected on Sheet M, cell F5Simply 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!G10Sheet M cell F7 would be: =SheetC!G10 etc. etc.MIKEhttp://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 EnterAnd 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