Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paintg cells withtout go sheet to sheet
My problem is:
I have a sheet1 to sheet10 with class marks created for each class and i have other sheets created for each studen. and some times i need to paint the cells with a diferent coulor and the problem is when a paint a cells i need to go to the student individual sheet and paint the respective cells that i have painted and that gives a lot of work. I wonder if there is any formula that permits me just to paint in the class sheet and then he will to the other part on the student individual sheet. Can any one help me and put the code... please |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paintg cells withtout go sheet to sheet
does the painting have some rhyme or reason? If it is based on numerical
scores/conditions, perhaps you can do the painting with conditional formatting. See Debra Dalgleish's site: http://www.contextures.com/tiptech.html look in the listing under C, then at conditional formatting. -- Regards, Tom Ogilvy "FredyHell" wrote in message ... My problem is: I have a sheet1 to sheet10 with class marks created for each class and i have other sheets created for each studen. and some times i need to paint the cells with a diferent coulor and the problem is when a paint a cells i need to go to the student individual sheet and paint the respective cells that i have painted and that gives a lot of work. I wonder if there is any formula that permits me just to paint in the class sheet and then he will to the other part on the student individual sheet. Can any one help me and put the code... please |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Sheet to new Sheet and clear cells on original sheets | Excel Discussion (Misc queries) | |||
copy data of two cells from Sheet 2 into one cell in Sheet 1 | Excel Worksheet Functions | |||
How do I link cells, sheet to sheet, to recognize row deletion | Excel Programming | |||
Copying cells from on sheet to another sheet (via sheet module) | Excel Programming | |||
Inserting a row in sheet A should Insert a row in sheet B, removing a row in Sheet A should remove the corresponding row in sheet B | Excel Programming |