Find the Closest Color Name for a Hex Value in Google Sheets Using OS_COLOR_NAME

Introduction

Are you searching for a way to identify the closest color name for a hex value within Google Sheets? Look no further! Utilizing the custom function OS_COLOR_NAME in OneScript, you can effortlessly obtain the corresponding color name for any hex value in Google Sheets.

Installation

Install from Google Workspace Marketplace

YouTube

If you're more of a visual learner, watch this video for step-by-step instructions. While you're there, consider subscribing to my channel for future updates and content.

Demo Use Case

In this demonstration, we'll be setting the primary color of the add-on OneScript. The primary color's hex value is “#FAE093”. In the second parameter, you can specify the number of slices for the color scale, with options ranging from 1 to 6, corresponding to 3 to 96 slices.

Example

OS_COLOR_NAME("#FAE093", 3)

About

Find the nearest name for a hex color.

---

hex_color

The color in hex value.

color_scale_slices

1 (x3), 2 (x6), 3 (x12), 4(x24), 5 (x48), 6 (x96) (Default to 3).

* The more slices we have, the more accurate color names we may get.

OneScript Custom Functions (Follow for More Updates)

Links

Hire Me on Upwork Donate YouTube Github Twitter / X Instagram Upwork Projects