Cell Color
I need help with cell shading. I am trying to make a cell color of a cell in a Gradebook, under Tuesday, with the letter "H" in it
show in a cell in a worksheet named "week1", under Tuesday, with the word "Homework" in it.
In other words, when I change the the color of cell (D5) of the Gradebook it will also change in cell (F8) of the worksheet name "week1".
I hope you can understand what I am asking. If you do, what code would I put in the worksheet to get the new color?
Last edited by Mr_Quick; 04-15-2010 at 06:08 AM. Reason: removed fancy font formatting
There's no need for the Bold Font & use the attach button to attach files on the Forum, workbooks being far more useful than images
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Mr Quick, welcome to the forum.
Please go easy on the formatting, and use the forum facilities to upload files, rather than untrusted external sites.
In general, if you need help with pictures, post pictures, but if you need help with Excel, ....
Thanks for the advice and sorry for the links back to my site. I was having issues with the attachment pop-up window, I think it was a Firefox browser problem; It worked when I tried it a second time.Originally Posted by teylyn
Thanks for the advice and sorry for the links back to my site. I was having issues with the attachment pop-up window. I think it was a Firefox browser problem; It worked when I tried it a second time.
Post the workbook. There's no telling from your picture which cell is which.
Thanks for the advice again. I got rid of the pictures and added an example of what I am trying to do. I would love to figure this one out -been pulling my hair out for 2 days.
So what are the rules? Just simply copy the color of cell D5 on sheet "Gradebook" to F8 on sheet "week1"?
Somehow I have a feeling it will be more complex than that.
This can only be achieved by VBA, as far as my experience goes, and you'd better spell out all the rules and circumstances before someone tries to tackle this.
Your data sample does not have any data, but I'm fairly sure that data and values might play a part in it.
For a macro-free solution, you could use adjacent cells in sheet "Gradebook", e.g. E5 and enter "green". Then E5 could be colored with conditional formatting, and week1!F8 could also be conditionally formatted based on that cell, if a few things like range names are set up first.
But I think it might be better to step back and explain the concept in full, otherwise we'll end up tweaking a less than perfect workaround into a solution for the bigger picture.
Last edited by teylyn; 04-14-2010 at 06:52 PM.
Yes, this is what I want. The only complex thing is that I want the color of F8 to change whenever I change the color of D5.
There is no code in these cells. The only formatting will be the cell color.
Ok, maybe if I explain it this way, you will understand. I want (F8) in "week1" to shade automatically when I manually shade (D5) in "gradebook."
OK,
right-click on the sheet tab for the week1 sheet, click View Code to open the VB Editor and copy this code into the code window:
Close the VB Editor and make sure to save your file as a macro-enabled file with the .xlsm extension.
Please Login or Register to view this content.
cheers
Thank you, thank you, and thank you again! That was exactly what I was trying to figure out.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks