Results 1 to 2 of 2

Find the closest colour block for each pixel

Threaded View

LiamS47 Find the closest colour block... 01-14-2020, 06:06 AM
Pepe Le Mokko Re: Help with a formula,... 01-14-2020, 07:50 AM
  1. #1
    Registered User
    Join Date
    01-14-2020
    Location
    UK
    MS-Off Ver
    2010 (I think)
    Posts
    1

    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
    Last edited by LiamS47; 01-14-2020 at 08:22 AM. Reason: Titile change

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 3
    Last Post: 01-10-2019, 09:34 AM
  2. Replies: 5
    Last Post: 02-16-2018, 06:50 AM
  3. Replies: 8
    Last Post: 09-22-2017, 05:41 AM
  4. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  5. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  6. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1