Find the closest colour block for each pixel

I am using Excel to help me create art in Minecraft with my children. I've worked out the RGB values of each block in the game and the values of each pixel in the picture I want to create. To begin with I'm unsure whether I should have each of the RGB values in separate cells or in one cell? (i.e. Row A is all R values, Row B is all G values and Row C is all B values OR Should it be set out as 128,91,100 for the R,G,B values) Secondly, once that has been decided on, I need to know how to find the closest colour block for each pixel (i.e. the pixel may be 100,100,100 and the blocks may consist of these three:block1 is 100,99,101, block2 is 30,27,237 and block3 is 250,90,8 … I want it to change the pixel values in the cell 100,100,100 to say block1 as that is the closest). Any help would be great. Thankyou

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

We usually do it ourselves for first-time posters, but I can't edit your post (forum glitch). I suggest something like "find the closest colour block for each pixel"