### [Solved] Determine best match in RGB color matrix

Posted:

**Fri Apr 30, 2021 4:42 am**Hi OpenOfficeistas! I am color blind and have a technique for selecting colors. I am seeking an approach in the Calc part of OpenOffice to find the nearest Red, Green, and Blue values from a prexisting table of paints. B7:B18 in the attached spreadsheet are the paint colors I have. I can use a smartphone camera to detect a color. For example, Red value of 10, green value of 191 and blue value of 163 (out of 255). I use the INDEX and MATCH functions to find the paint color nearest my chosen color. For example, in the attached spreadsheet the Red value of 4 is nearest the 206 value on row 10. The issue is how to detect the nearest value from all 3 colors? For example, the row that is nearest a Red value of 10, Green value of 191, and Blue value of 163. -Frank