# Colours as data
**URL:** https://community.glideapps.com/t/colours-as-data/14345
**Category:** Feature Requests
**Created:** [August 21, 2020, 6:51pm UTC](https://community.glideapps.com/t/colours-as-data/14345 "2020-08-21T18:51:02Z")
**Posts on this page:** 2
**Page:** 1
### Author:  [@Stephen\_Spackman](https://community.glideapps.com/u/Stephen_Spackman)
#### Post date: [August 21, 2020, 6:51pm UTC](https://community.glideapps.com/t/colours-as-data/14345/1 "2020-08-21T18:51:02Z")
I want to implement a colour catalogue (for paint selection, but this hardly matters). I have RGB (or any other colour space you like) in my spreadsheet; now I need to be able to use it to make a swatch in my application view. A few things would work, for example control of foreground/background for text elements, or a pseudo- image type that consists of just an RGB code (this latter seems more clunky, but leaves the door open for things like computed gradients, which would be a useful enhancement).
What I _don’t_ want to have to do is make sixteen million pngs, or rely on an external image generator (although of course these exist, and could be used for prototyping).
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [August 21, 2020, 7:26pm UTC](https://community.glideapps.com/t/colours-as-data/14345/2 "2020-08-21T19:26:34Z")
Use Cloudinary! Find a white square image online, fetch it and then colorize it using a hex code.
Eg.
[https://res.cloudinary.com/YOURUSERNAME/image/fetch/e\_colorize,co\_rgb:HEXCODE/LINKTOSQUAREIMAGE.png](https://res.cloudinary.com/YOURUSERNAME/image/fetch/e_colorize,co_rgb:HEXCODE/LINKTOSQUAREIMAGE.png)
For a formula, given that the hex codes are in Column A:
`ARRAYFORMULA("https://res.cloudinary.com/YOURUSERNAME/image/fetch/e_colorize,co_rgb:"&A2:A&"/LINKTOSQUAREIMAGE.png")`