Gallery
Share
Explore
Link to page
info

The objective of this Doc is to have a “simple” way to customize colors.

It is inspired by discussions on the forum. Special thanks to
Scott_Collier-Weir
⁠
and
Paul_Danyliuk
⁠
.
My main goals were to simplify the process and have a way to automatically adapt font color.
See discussion
here
⁠
about font color vs. overall background intensity.
The threshold for overall intensity can be customized with the following control (named c_Threshold):
000
146
⁠
⁠
⁠
Color table with all columns
Name
R
G
B
HEX
Intensity
Mirror
Black
000
0
000
0
000
0
#000000
0
White
000
255
000
255
000
255
#FFFFFF
255
Red
000
255
000
0
000
0
#FF0000
76
Green
000
0
000
255
000
0
#00FF00
150
Blue
000
0
000
0
000
255
#0000FF
29
Cyan
000
0
000
255
000
255
#00FFFF
179
Magenta
000
255
000
0
000
255
#FF00FF
105
Yellow
000
255
000
255
000
0
#FFFF00
226
Custom 1
000
211
000
82
000
30
#D3521E
115
Custom 2
000
62
000
197
000
177
#3EC5B1
154
There are no rows in this table
⁠
⁠
The HEX column formula is

Concatenate("#",
ToHexadecimal(thisRow.R,2),
ToHexadecimal(thisRow.G,2),
ToHexadecimal(thisRow.B,2))
The Intensity column formula is

thisRow.R*0.299 + thisRow.G*0.587 + thisRow.B*0.114
The first formula for conditional formatting is
_GRADIENT(1, 1, thisRow.HEX)
The second one applies white font when
thisRow.Intensity < c_Threshold
⁠
Cards with RGB sliders
Black
000
0
000
0
000
0
White
000
255
000
255
000
255
Red
000
255
000
0
000
0
Green
000
0
000
255
000
0
Blue
000
0
000
0
000
255
Cyan
000
0
000
255
000
255
Magenta
000
255
000
0
000
255
Yellow
000
255
000
255
000
0
Custom 1
000
211
000
82
000
30
Custom 2
000
62
000
197
000
177
⁠
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.