I would like to be able to automatically have excel change the cell color in column "L" by using the Red Green Blue values that are defined in the corresponding Columns "F-G". I have attached a sheet to use as a reference. I don't have a clue where to start. I would only have a maximum of 15 rows. Thanks,
hi Chris
Give this a try: Rightclick on Sheet Tab, view code and paste in.
Please Login or Register to view this content.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
It doesn't seem to work?
Have a look at sample file!
Originally Posted by Chris McGlothen
Please Login or Register to view this content.
Glad i could contribute.Thanks for the rep points.
Does this help?
John, it does help, but I have the RGB Colors being added via a Vlookup process based off of the Pantone Color. When it populates the RGB Fields, it doesn't change the cell color unless I manually type in one of the RGB Values.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks