Hello,
I wonder if the thing I need is possible in Excel.
A1, B1, C1, D1, E1, F1 would have the title.
A2: when I will write some numbers here, a drop-down should appear while I type so I could easily choose from the values there (the dropdown will contain my 490ish values I have already)
B2 will contain A1's name in words.
B3, B4, B5 would automatically display A2's RGB values I already have.
B5 should display the RGB value as a solid color - this would be so awesome to have also!
For example:
A2 B2 B3 B4 B5
300 Color-name 255 255 255
Now this part would be repeated also in the G1 to L1.
The difficult part I think would be this one: N1.
I do want that N1 to display the medium value of the previous two, as an RGB color (For example: if A2 has the perfect yellow and H2 has the perfect blue, N1 will show the perfect green/or the medium RGB value based on the yello+blue together)
Thank you!
I wonder if the thing I need is possible in Excel.
A1, B1, C1, D1, E1, F1 would have the title.
A2: when I will write some numbers here, a drop-down should appear while I type so I could easily choose from the values there (the dropdown will contain my 490ish values I have already)
B2 will contain A1's name in words.
B3, B4, B5 would automatically display A2's RGB values I already have.
B5 should display the RGB value as a solid color - this would be so awesome to have also!
For example:
A2 B2 B3 B4 B5
300 Color-name 255 255 255
Now this part would be repeated also in the G1 to L1.
The difficult part I think would be this one: N1.
I do want that N1 to display the medium value of the previous two, as an RGB color (For example: if A2 has the perfect yellow and H2 has the perfect blue, N1 will show the perfect green/or the medium RGB value based on the yello+blue together)
Thank you!