Dislay RGB color and medium of some RGB values

ovisergiu

New Member
Joined
Apr 30, 2019
Messages
2
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!
 

Attachments

  • Screenshot from 2021-09-01 08-22-39.png
    Screenshot from 2021-09-01 08-22-39.png
    15.2 KB · Views: 16

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"

Forum statistics

Threads
1,223,903
Messages
6,175,289
Members
452,631
Latest member
a_potato

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top