Hi all, this is my first post here and below my questions:
I have a File with 2 sheets:
in the sheet named COLOR_TABLE I defined:
a list of Color ID number (from 0 to 255) shown in column A
the RGB color Values (between 0-255 each) for each ID Number shown in the range between columns B:D
finlally, in the column E, the cells are filled according to RGB Values throug Private Sub as per attached Code Source
Then, I have a sheet named COLOR_MAPPING where I defined:
a list of elements (in three nested level) shown in the range between columns A:C
the Level ID number and/or name and Color ID number for each element shown in the range between columns D:E (NOTE that this is the CASE 1 relevant to Projection view Representation of Elemenet)
the RGB color Values (using VLOOKUP Formula referring the COLOR_TABLE sheet) shown in the range between columns F:H
finally, in the column I the cells should be filled accordingly (maybe using Code Source like the above attached Private Sub?)
the Level ID number and/or name and Color ID number for each element shown in the range between columns J:K (NOTE that this is the CASE 2 relevant to Cut view Representation of Elemenet)
the RGB color Values (using VLOOKUP Formula referring the COLOR_TABLE sheet) shown in the range between columns L:N
finally, in the column O the cells should be filled accordingly (maybe using Code Source like the above attached Private Sub?)
Since I'm not able to modify the above attached Source VBA Code, I'm here hoping that somwbody will be able to help me on this matter
Please Note that I would like to see change the background cell color whenever the relative ID number will be changed (even modified in E or K columns)
Thanks in advance for your support....
Bookmarks