RGB colors with Their respective values in one sheet macro

witsonjoyet · Dec 23, 2019

Hi,
Good Day,
Could anyone write a macro to show the all RGB colours (1.6 million) in one single sheet with a RGB number. I.e. if i place the cursor in a cell then it needs to show/pop-up the RGB value of a particular cell, like wise i need to show the entire 1.6 million RGB colours in one sheet (if possible).
Thanks in advance.

Yongle · Dec 26, 2019

witsonjoyet said:
i need to show the entire 1.6 million RGB colours in one sheet (if possible).

it is NOT possible in one sheet - requires 250 sheets

witsonjoyet said:
some how i need to show the color variances too

To show a variance requires 2 colours
- do you want to show a variance between colours in 2 cells ?
- how should the value of the variance be returned ?

YasserKhalil · Dec 26, 2019

witsonjoyet said:
Hi,

Thanks for your suggestion, i followed it, still i am getting error message at 64,096th row.

I think you have first to delete all the cells in your worksheet then save and close the workbook. After that try the code again ..

Zenwood · Dec 26, 2019

This will give you the color of the active cell.

VBA Code:

Sub RGB_Peek()

'    Shift + Ctrl + Z
'    Paul Pfau 2019

     InteriorColor_ = ActiveCell.Interior.Color
     
          Red_ = InteriorColor_ And 255
          Green_ = InteriorColor_ \ 256 And 255
          Blue_ = InteriorColor_ \ 256 ^ 2 And 255
     
     Answer_ = "RGB = " & Red_ & " " & Green_ & " " & Blue_ & vbCrLf & "Interior Color = " & InteriorColor_
     
     MsgBox Answer_

End Sub

Zenwood · Dec 26, 2019

This code will give you 512 of the colors.

VBA Code:

Sub RGB_512()

Application.ScreenUpdating = False

Dim Add_ As Long
Dim Step_ As Long
Dim Square_ As Long

Dim InteriorColor_ As Long

Dim Red_ As Long
Dim Green_ As Long
Dim Blue_ As Long

Dim RedDark_ As Long
Dim GreenDark_ As Long
Dim BlueDark_ As Long

Dim RedLight_ As Long
Dim GreenLight_ As Long
Dim BlueLight_ As Long

Dim RedBorder_ As Long
Dim GreenBorder_ As Long
Dim BlueBorder_ As Long

Sheets("Color Chart").Select

'Red_ = 200: Green_ = 200: Blue_ = 200: Add_ = 50: Step_ = 10: Square_ = 6 * -6     '    216 light
Red_ = 180: Green_ = 180: Blue_ = 180: Add_ = 70: Step_ = 10: Square_ = 8 * -8     '    512 Light
'Red_ = 100:Green_ = 100:Blue_ = 100:Add_ = 140:Step_ = 20:Square_ = 8 * -8     '    512 Medium
'Red_ = 0: Green_ = 0: Blue_ = 0: Add_ = 256: Step_ = 64: Square_ = 5 * -5     '    125 All

'    Start set
RedDark_ = Red_
GreenDark_ = Green_
BlueDark_ = Blue_

'    End set
RedLight_ = Red_ + Add_
GreenLight_ = Green_ + Add_
BlueLight_ = Blue_ + Add_

Cells(1, 1).Select

     For Red_ = RedDark_ To RedLight_ Step Step_
     For Green_ = GreenDark_ To GreenLight_ Step Step_
     For Blue_ = BlueDark_ To BlueLight_ Step Step_
     
          RedBorder_ = Red_ - 20: If RedBorder_ < 0 Then RedBorder_ = 0
          GreenBorder_ = Green_ - 20: If GreenBorder_ < 0 Then GreenBorder_ = 0
          BlueBorder_ = Blue_ - 20: If BlueBorder_ < 0 Then BlueBorder_ = 0
          
          ActiveCell.Interior.Color = RGB(Red_, Green_, Blue_)
          ActiveCell.Borders.Color = RGB(RedBorder_, GreenBorder_, BlueBorder_)
InteriorColor_ = ActiveCell.Interior.Color
ActiveCell.Value = Format(Red_, "000") & " " & Format(Green_, "000") & " " & Format(Blue_, "000" & " — " & InteriorColor_)
          ActiveCell.Offset(1, 0).Select
     
     Next Blue_
     Next Green_
     ActiveCell.Offset(0, 1).Select
     ActiveCell.Offset(Square_, 0).Select
     Next Red_

Application.ScreenUpdating = True

End Sub

DanteAmor · Dec 26, 2019

Maybe you don't need to have all the colors (16 million) on the sheet.
It may be sufficient to have the corresponding colors on the screen.
That is, every time you scroll through the sheet, and select a cell, a code will be activated and paint the cells you have on the screen.

Run the following macro only to put the RGB codes in the 16 million cells, from cell A1 to cell IV65536.

VBA Code:

Sub RGB_Colors()
  Dim r As Long, g As Long, b As Long, i As Long, j As Long
  i = 1
  j = 1
  For r = 0 To 255
    For g = 0 To 255
      For b = 0 To 255
        Cells(i, j).Value = "RGB(" & r & "," & g & "," & b & ")"
        i = i + 1
      Next
    Next
    j = j + 1
    i = 1
  Next
End Sub

___________________________________________________________
Put the following code in the events on the sheet.

VBA Code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
  If Target.CountLarge > 1 Then Exit Sub
  If Target.Value = "" Then Exit Sub
  If Left(Target.Value, 4) <> "RGB(" Then Exit Sub
  
  Dim ri As Long, ci As Long, rn As Range, c As Range, cs, r, g, b
  
  Application.ScreenUpdating = False
  
  Cells.Interior.Color = xlNone
  If Target.Row < 25 Then ri = 1 Else ri = Target.Row - 25
  If Target.Column < 16 Then ci = 1 Else ci = Target.Column - 16
  Set rn = Range(Cells(ri, ci), Cells(Target.Row + 25, Target.Column + 16))
  For Each c In rn
    If Left(c.Value, 4) = "RGB(" Then
      cs = Split(Replace(Replace(c, ")", ""), "RGB(", ""), ",")
      r = Val(cs(0))
      g = Val(cs(1))
      b = Val(cs(2))
      c.Interior.Color = RGB(r, g, b)
    End If
  Next
End Sub

___________________________________________________

Each time you select a cell, the macro on sheet will paint the cells you see on the screen, the result will be something like this:

Book1

A

B

C

D

E

F

G

H

I

J

K

L

M

1

RGB(25,25,50)

RGB(25,50,50)

RGB(25,75,50)

RGB(25,100,50)

RGB(25,125,50)

RGB(25,150,50)

RGB(25,175,50)

RGB(25,200,50)

RGB(25,225,50)

RGB(25,250,50)

RGB(25,275,50)

RGB(25,300,50)

RGB(25,325,50)

2

RGB(25,25,75)

RGB(25,50,75)

RGB(25,75,75)

RGB(25,100,75)

RGB(25,125,75)

RGB(25,150,75)

RGB(25,175,75)

RGB(25,200,75)

RGB(25,225,75)

RGB(25,250,75)

RGB(25,275,75)

RGB(25,300,75)

RGB(25,325,75)

3

RGB(25,25,100)

RGB(25,50,100)

RGB(25,75,100)

RGB(25,100,100)

RGB(25,125,100)

RGB(25,150,100)

RGB(25,175,100)

RGB(25,200,100)

RGB(25,225,100)

RGB(25,250,100)

RGB(25,275,100)

RGB(25,300,100)

RGB(25,325,100)

4

RGB(25,25,125)

RGB(25,50,125)

RGB(25,75,125)

RGB(25,100,125)

RGB(25,125,125)

RGB(25,150,125)

RGB(25,175,125)

RGB(25,200,125)

RGB(25,225,125)

RGB(25,250,125)

RGB(25,275,125)

RGB(25,300,125)

RGB(25,325,125)

5

RGB(25,25,150)

RGB(25,50,150)

RGB(25,75,150)

RGB(25,100,150)

RGB(25,125,150)

RGB(25,150,150)

RGB(25,175,150)

RGB(25,200,150)

RGB(25,225,150)

RGB(25,250,150)

RGB(25,275,150)

RGB(25,300,150)

RGB(25,325,150)

6

RGB(25,25,175)

RGB(25,50,175)

RGB(25,75,175)

RGB(25,100,175)

RGB(25,125,175)

RGB(25,150,175)

RGB(25,175,175)

RGB(25,200,175)

RGB(25,225,175)

RGB(25,250,175)

RGB(25,275,175)

RGB(25,300,175)

RGB(25,325,175)

7

RGB(25,25,200)

RGB(25,50,200)

RGB(25,75,200)

RGB(25,100,200)

RGB(25,125,200)

RGB(25,150,200)

RGB(25,175,200)

RGB(25,200,200)

RGB(25,225,200)

RGB(25,250,200)

RGB(25,275,200)

RGB(25,300,200)

RGB(25,325,200)

8

RGB(25,25,225)

RGB(25,50,225)

RGB(25,75,225)

RGB(25,100,225)

RGB(25,125,225)

RGB(25,150,225)

RGB(25,175,225)

RGB(25,200,225)

RGB(25,225,225)

RGB(25,250,225)

RGB(25,275,225)

RGB(25,300,225)

RGB(25,325,225)

9

RGB(25,25,250)

RGB(25,50,250)

RGB(25,75,250)

RGB(25,100,250)

RGB(25,125,250)

RGB(25,150,250)

RGB(25,175,250)

RGB(25,200,250)

RGB(25,225,250)

RGB(25,250,250)

RGB(25,275,250)

RGB(25,300,250)

RGB(25,325,250)

10

RGB(25,25,275)

RGB(25,50,275)

RGB(25,75,275)

RGB(25,100,275)

RGB(25,125,275)

RGB(25,150,275)

RGB(25,175,275)

RGB(25,200,275)

RGB(25,225,275)

RGB(25,250,275)

RGB(25,275,275)

RGB(25,300,275)

RGB(25,325,275)

11

RGB(25,25,300)

RGB(25,50,300)

RGB(25,75,300)

RGB(25,100,300)

RGB(25,125,300)

RGB(25,150,300)

RGB(25,175,300)

RGB(25,200,300)

RGB(25,225,300)

RGB(25,250,300)

RGB(25,275,300)

RGB(25,300,300)

RGB(25,325,300)

12

RGB(25,25,325)

RGB(25,50,325)

RGB(25,75,325)

RGB(25,100,325)

RGB(25,125,325)

RGB(25,150,325)

RGB(25,175,325)

RGB(25,200,325)

RGB(25,225,325)

RGB(25,250,325)

RGB(25,275,325)

RGB(25,300,325)

RGB(25,325,325)

13

RGB(25,25,350)

RGB(25,50,350)

RGB(25,75,350)

RGB(25,100,350)

RGB(25,125,350)

RGB(25,150,350)

RGB(25,175,350)

RGB(25,200,350)

RGB(25,225,350)

RGB(25,250,350)

RGB(25,275,350)

RGB(25,300,350)

RGB(25,325,350)

14

RGB(25,25,375)

RGB(25,50,375)

RGB(25,75,375)

RGB(25,100,375)

RGB(25,125,375)

RGB(25,150,375)

RGB(25,175,375)

RGB(25,200,375)

RGB(25,225,375)

RGB(25,250,375)

RGB(25,275,375)

RGB(25,300,375)

RGB(25,325,375)

15

RGB(25,25,400)

RGB(25,50,400)

RGB(25,75,400)

RGB(25,100,400)

RGB(25,125,400)

RGB(25,150,400)

RGB(25,175,400)

RGB(25,200,400)

RGB(25,225,400)

RGB(25,250,400)

RGB(25,275,400)

RGB(25,300,400)

RGB(25,325,400)

16

RGB(25,25,425)

RGB(25,50,425)

RGB(25,75,425)

RGB(25,100,425)

RGB(25,125,425)

RGB(25,150,425)

RGB(25,175,425)

RGB(25,200,425)

RGB(25,225,425)

RGB(25,250,425)

RGB(25,275,425)

RGB(25,300,425)

RGB(25,325,425)

17

RGB(25,25,450)

RGB(25,50,450)

RGB(25,75,450)

RGB(25,100,450)

RGB(25,125,450)

RGB(25,150,450)

RGB(25,175,450)

RGB(25,200,450)

RGB(25,225,450)

RGB(25,250,450)

RGB(25,275,450)

RGB(25,300,450)

RGB(25,325,450)

18

RGB(25,25,475)

RGB(25,50,475)

RGB(25,75,475)

RGB(25,100,475)

RGB(25,125,475)

RGB(25,150,475)

RGB(25,175,475)

RGB(25,200,475)

RGB(25,225,475)

RGB(25,250,475)

RGB(25,275,475)

RGB(25,300,475)

RGB(25,325,475)

19

RGB(25,25,500)

RGB(25,50,500)

RGB(25,75,500)

RGB(25,100,500)

RGB(25,125,500)

RGB(25,150,500)

RGB(25,175,500)

RGB(25,200,500)

RGB(25,225,500)

RGB(25,250,500)

RGB(25,275,500)

RGB(25,300,500)

RGB(25,325,500)

20

RGB(25,25,525)

RGB(25,50,525)

RGB(25,75,525)

RGB(25,100,525)

RGB(25,125,525)

RGB(25,150,525)

RGB(25,175,525)

RGB(25,200,525)

RGB(25,225,525)

RGB(25,250,525)

RGB(25,275,525)

RGB(25,300,525)

RGB(25,325,525)

21

RGB(25,25,550)

RGB(25,50,550)

RGB(25,75,550)

RGB(25,100,550)

RGB(25,125,550)

RGB(25,150,550)

RGB(25,175,550)

RGB(25,200,550)

RGB(25,225,550)

RGB(25,250,550)

RGB(25,275,550)

RGB(25,300,550)

RGB(25,325,550)

22

RGB(25,25,575)

RGB(25,50,575)

RGB(25,75,575)

RGB(25,100,575)

RGB(25,125,575)

RGB(25,150,575)

RGB(25,175,575)

RGB(25,200,575)

RGB(25,225,575)

RGB(25,250,575)

RGB(25,275,575)

RGB(25,300,575)

RGB(25,325,575)

23

RGB(25,25,600)

RGB(25,50,600)

RGB(25,75,600)

RGB(25,100,600)

RGB(25,125,600)

RGB(25,150,600)

RGB(25,175,600)

RGB(25,200,600)

RGB(25,225,600)

RGB(25,250,600)

RGB(25,275,600)

RGB(25,300,600)

RGB(25,325,600)

24

RGB(25,25,625)

RGB(25,50,625)

RGB(25,75,625)

RGB(25,100,625)

RGB(25,125,625)

RGB(25,150,625)

RGB(25,175,625)

RGB(25,200,625)

RGB(25,225,625)

RGB(25,250,625)

RGB(25,275,625)

RGB(25,300,625)

RGB(25,325,625)

Sheet1

Yongle · Dec 26, 2019

@DanteAmor

witsonjoyet · Dec 27, 2019

DanteAmor said:
Maybe you don't need to have all the colors (16 million) on the sheet.
It may be sufficient to have the corresponding colors on the screen.
That is, every time you scroll through the sheet, and select a cell, a code will be activated and paint the cells you have on the screen.

Run the following macro only to put the RGB codes in the 16 million cells, from cell A1 to cell IV65536.

VBA Code:

Sub RGB_Colors() Dim r As Long, g As Long, b As Long, i As Long, j As Long i = 1 j = 1 For r = 0 To 255 For g = 0 To 255 For b = 0 To 255 Cells(i, j).Value = "RGB(" & r & "," & g & "," & b & ")" i = i + 1 Next Next j = j + 1 i = 1 Next End Sub

___________________________________________________________
Put the following code in the events on the sheet.

VBA Code:

Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.CountLarge > 1 Then Exit Sub If Target.Value = "" Then Exit Sub If Left(Target.Value, 4) <> "RGB(" Then Exit Sub Dim ri As Long, ci As Long, rn As Range, c As Range, cs, r, g, b Application.ScreenUpdating = False Cells.Interior.Color = xlNone If Target.Row < 25 Then ri = 1 Else ri = Target.Row - 25 If Target.Column < 16 Then ci = 1 Else ci = Target.Column - 16 Set rn = Range(Cells(ri, ci), Cells(Target.Row + 25, Target.Column + 16)) For Each c In rn If Left(c.Value, 4) = "RGB(" Then cs = Split(Replace(Replace(c, ")", ""), "RGB(", ""), ",") r = Val(cs(0)) g = Val(cs(1)) b = Val(cs(2)) c.Interior.Color = RGB(r, g, b) End If Next End Sub

___________________________________________________

Each time you select a cell, the macro on sheet will paint the cells you see on the screen, the result will be something like this:

Book1
A B C D E F G H I J K L M
1 RGB(25,25,50) RGB(25,50,50) RGB(25,75,50) RGB(25,100,50) RGB(25,125,50) RGB(25,150,50) RGB(25,175,50) RGB(25,200,50) RGB(25,225,50) RGB(25,250,50) RGB(25,275,50) RGB(25,300,50) RGB(25,325,50)
2 RGB(25,25,75) RGB(25,50,75) RGB(25,75,75) RGB(25,100,75) RGB(25,125,75) RGB(25,150,75) RGB(25,175,75) RGB(25,200,75) RGB(25,225,75) RGB(25,250,75) RGB(25,275,75) RGB(25,300,75) RGB(25,325,75)
3 RGB(25,25,100) RGB(25,50,100) RGB(25,75,100) RGB(25,100,100) RGB(25,125,100) RGB(25,150,100) RGB(25,175,100) RGB(25,200,100) RGB(25,225,100) RGB(25,250,100) RGB(25,275,100) RGB(25,300,100) RGB(25,325,100)
4 RGB(25,25,125) RGB(25,50,125) RGB(25,75,125) RGB(25,100,125) RGB(25,125,125) RGB(25,150,125) RGB(25,175,125) RGB(25,200,125) RGB(25,225,125) RGB(25,250,125) RGB(25,275,125) RGB(25,300,125) RGB(25,325,125)
5 RGB(25,25,150) RGB(25,50,150) RGB(25,75,150) RGB(25,100,150) RGB(25,125,150) RGB(25,150,150) RGB(25,175,150) RGB(25,200,150) RGB(25,225,150) RGB(25,250,150) RGB(25,275,150) RGB(25,300,150) RGB(25,325,150)
6 RGB(25,25,175) RGB(25,50,175) RGB(25,75,175) RGB(25,100,175) RGB(25,125,175) RGB(25,150,175) RGB(25,175,175) RGB(25,200,175) RGB(25,225,175) RGB(25,250,175) RGB(25,275,175) RGB(25,300,175) RGB(25,325,175)
7 RGB(25,25,200) RGB(25,50,200) RGB(25,75,200) RGB(25,100,200) RGB(25,125,200) RGB(25,150,200) RGB(25,175,200) RGB(25,200,200) RGB(25,225,200) RGB(25,250,200) RGB(25,275,200) RGB(25,300,200) RGB(25,325,200)
8 RGB(25,25,225) RGB(25,50,225) RGB(25,75,225) RGB(25,100,225) RGB(25,125,225) RGB(25,150,225) RGB(25,175,225) RGB(25,200,225) RGB(25,225,225) RGB(25,250,225) RGB(25,275,225) RGB(25,300,225) RGB(25,325,225)
9 RGB(25,25,250) RGB(25,50,250) RGB(25,75,250) RGB(25,100,250) RGB(25,125,250) RGB(25,150,250) RGB(25,175,250) RGB(25,200,250) RGB(25,225,250) RGB(25,250,250) RGB(25,275,250) RGB(25,300,250) RGB(25,325,250)
10 RGB(25,25,275) RGB(25,50,275) RGB(25,75,275) RGB(25,100,275) RGB(25,125,275) RGB(25,150,275) RGB(25,175,275) RGB(25,200,275) RGB(25,225,275) RGB(25,250,275) RGB(25,275,275) RGB(25,300,275) RGB(25,325,275)
11 RGB(25,25,300) RGB(25,50,300) RGB(25,75,300) RGB(25,100,300) RGB(25,125,300) RGB(25,150,300) RGB(25,175,300) RGB(25,200,300) RGB(25,225,300) RGB(25,250,300) RGB(25,275,300) RGB(25,300,300) RGB(25,325,300)
12 RGB(25,25,325) RGB(25,50,325) RGB(25,75,325) RGB(25,100,325) RGB(25,125,325) RGB(25,150,325) RGB(25,175,325) RGB(25,200,325) RGB(25,225,325) RGB(25,250,325) RGB(25,275,325) RGB(25,300,325) RGB(25,325,325)
13 RGB(25,25,350) RGB(25,50,350) RGB(25,75,350) RGB(25,100,350) RGB(25,125,350) RGB(25,150,350) RGB(25,175,350) RGB(25,200,350) RGB(25,225,350) RGB(25,250,350) RGB(25,275,350) RGB(25,300,350) RGB(25,325,350)
14 RGB(25,25,375) RGB(25,50,375) RGB(25,75,375) RGB(25,100,375) RGB(25,125,375) RGB(25,150,375) RGB(25,175,375) RGB(25,200,375) RGB(25,225,375) RGB(25,250,375) RGB(25,275,375) RGB(25,300,375) RGB(25,325,375)
15 RGB(25,25,400) RGB(25,50,400) RGB(25,75,400) RGB(25,100,400) RGB(25,125,400) RGB(25,150,400) RGB(25,175,400) RGB(25,200,400) RGB(25,225,400) RGB(25,250,400) RGB(25,275,400) RGB(25,300,400) RGB(25,325,400)
16 RGB(25,25,425) RGB(25,50,425) RGB(25,75,425) RGB(25,100,425) RGB(25,125,425) RGB(25,150,425) RGB(25,175,425) RGB(25,200,425) RGB(25,225,425) RGB(25,250,425) RGB(25,275,425) RGB(25,300,425) RGB(25,325,425)
17 RGB(25,25,450) RGB(25,50,450) RGB(25,75,450) RGB(25,100,450) RGB(25,125,450) RGB(25,150,450) RGB(25,175,450) RGB(25,200,450) RGB(25,225,450) RGB(25,250,450) RGB(25,275,450) RGB(25,300,450) RGB(25,325,450)
18 RGB(25,25,475) RGB(25,50,475) RGB(25,75,475) RGB(25,100,475) RGB(25,125,475) RGB(25,150,475) RGB(25,175,475) RGB(25,200,475) RGB(25,225,475) RGB(25,250,475) RGB(25,275,475) RGB(25,300,475) RGB(25,325,475)
19 RGB(25,25,500) RGB(25,50,500) RGB(25,75,500) RGB(25,100,500) RGB(25,125,500) RGB(25,150,500) RGB(25,175,500) RGB(25,200,500) RGB(25,225,500) RGB(25,250,500) RGB(25,275,500) RGB(25,300,500) RGB(25,325,500)
20 RGB(25,25,525) RGB(25,50,525) RGB(25,75,525) RGB(25,100,525) RGB(25,125,525) RGB(25,150,525) RGB(25,175,525) RGB(25,200,525) RGB(25,225,525) RGB(25,250,525) RGB(25,275,525) RGB(25,300,525) RGB(25,325,525)
21 RGB(25,25,550) RGB(25,50,550) RGB(25,75,550) RGB(25,100,550) RGB(25,125,550) RGB(25,150,550) RGB(25,175,550) RGB(25,200,550) RGB(25,225,550) RGB(25,250,550) RGB(25,275,550) RGB(25,300,550) RGB(25,325,550)
22 RGB(25,25,575) RGB(25,50,575) RGB(25,75,575) RGB(25,100,575) RGB(25,125,575) RGB(25,150,575) RGB(25,175,575) RGB(25,200,575) RGB(25,225,575) RGB(25,250,575) RGB(25,275,575) RGB(25,300,575) RGB(25,325,575)
23 RGB(25,25,600) RGB(25,50,600) RGB(25,75,600) RGB(25,100,600) RGB(25,125,600) RGB(25,150,600) RGB(25,175,600) RGB(25,200,600) RGB(25,225,600) RGB(25,250,600) RGB(25,275,600) RGB(25,300,600) RGB(25,325,600)
24 RGB(25,25,625) RGB(25,50,625) RGB(25,75,625) RGB(25,100,625) RGB(25,125,625) RGB(25,150,625) RGB(25,175,625) RGB(25,200,625) RGB(25,225,625) RGB(25,250,625) RGB(25,275,625) RGB(25,300,625) RGB(25,325,625)
Sheet1

Hi ,
Good Day,
Thanks for your code, its works like a charm. Thank You Very Much

Regareds
Witson

DanteAmor · Dec 27, 2019

I'm glad to help you. Thanks for the feedback.

Zenwood · Dec 27, 2019

Thanks

Zenwood · Dec 27, 2019

The 512 colors

Book1

A

B

C

D

E

F

G

H

1

180 180 018 — 11842740

190 180 018 — 11842750

200 180 018 — 11842760

210 180 018 — 11842770

220 180 018 — 11842780

230 180 018 — 11842790

240 180 001 — 11842880

250 180 018 — 11842810

2

180 180 001 — 12498190

190 180 019 — 12498110

200 180 019 — 12498120

210 180 019 — 12498130

220 180 019 — 12498140

230 180 019 — 12498150

240 180 019 — 12498160

250 180 019 — 12498170

3

180 180 020 — 13153460

190 180 020 — 13153470

200 180 020 — 13153480

210 180 020 — 13153490

220 180 002 — 13153500

230 180 020 — 13153510

240 180 020 — 13153520

250 180 020 — 13153530

4

180 180 002 — 13818820

190 180 002 — 13818830

200 180 002 — 13818840

210 180 002 — 13818850

220 180 002 — 13818860

230 180 002 — 13818870

240 180 002 — 13818880

250 180 002 — 13818890

5

180 180 022 — 14464180

190 180 022 — 14464190

200 180 002 — 14464220

210 180 022 — 14464210

220 180 022 — 14464220

230 180 022 — 14464230

240 180 022 — 14464240

250 180 022 — 14464250

6

180 180 023 — 15119540

190 180 023 — 15119550

200 180 023 — 15119560

210 180 023 — 15119570

220 180 023 — 15119580

230 180 023 — 15119590

240 180 002 — 15119630

250 180 023 — 15119610

7

180 180 002 — 15774940

190 180 024 — 15774910

200 180 024 — 15774920

210 180 024 — 15774930

220 180 024 — 15774940

230 180 024 — 15774950

240 180 024 — 15774960

250 180 024 — 15774970

8

180 180 002 — 16435260

190 180 002 — 16435270

200 180 002 — 16435280

210 180 002 — 16435290

220 180 000 — 16432350

230 180 002 — 16435310

240 180 002 — 16435320

250 180 002 — 16435330

9

180 190 001 — 11845380

190 190 018 — 11845310

200 190 018 — 11845320

210 190 018 — 11845330

220 190 018 — 11845340

230 190 018 — 11845350

240 190 018 — 11845360

250 190 018 — 11845370

10

180 190 000 — 12519660

190 190 000 — 12519670

200 190 000 — 12519680

210 190 000 — 12519690

220 190 000 — 12501790

230 190 000 — 12519710

240 190 000 — 12519720

250 190 000 — 12519730

11

180 190 002 — 13156020

190 190 002 — 13156030

200 190 002 — 13156040

210 190 002 — 13156050

220 190 002 — 13156060

230 190 002 — 13156070

240 190 002 — 13156080

250 190 002 — 13156090

12

180 190 021 — 13811380

190 190 021 — 13811390

200 190 002 — 13811410

210 190 021 — 13811410

220 190 021 — 13811420

230 190 021 — 13811430

240 190 021 — 13811440

250 190 021 — 13811450

13

180 190 022 — 14466740

190 190 022 — 14466750

200 190 022 — 14466760

210 190 022 — 14466770

220 190 022 — 14466780

230 190 022 — 14466790

240 190 002 — 14466820

250 190 022 — 14466810

14

180 190 002 — 15122130

190 190 023 — 15122110

200 190 023 — 15122120

210 190 023 — 15122130

220 190 023 — 15122140

230 190 023 — 15122150

240 190 023 — 15122160

250 190 023 — 15122170

15

180 190 024 — 15777460

190 190 024 — 15777470

200 190 024 — 15777480

210 190 024 — 15777490

220 190 002 — 15777540

230 190 024 — 15777510

240 190 024 — 15777520

250 190 024 — 15777530

16

180 190 025 — 16432820

190 190 025 — 16432830

200 190 025 — 16432840

210 190 025 — 16432850

220 190 025 — 16432860

230 190 025 — 16432870

240 190 025 — 16432880

250 190 025 — 16432890

17

180 200 018 — 11847860

190 200 018 — 11847870

200 200 018 — 11847880

210 200 018 — 11847890

220 200 001 — 11847980

230 200 018 — 11847910

240 200 018 — 11847920

250 200 018 — 11847930

18

180 200 001 — 12593220

190 200 001 — 12593230

200 200 001 — 12593240

210 200 001 — 12593250

220 200 001 — 12593260

230 200 001 — 12593270

240 200 001 — 12593280

250 200 001 — 12593290

19

180 200 020 — 13158580

190 200 020 — 13158590

200 200 002 — 13158600

210 200 020 — 13158610

220 200 020 — 13158620

230 200 020 — 13158630

240 200 020 — 13158640

250 200 020 — 13158650

20

180 200 021 — 13813940

190 200 021 — 13813950

200 200 021 — 13813960

210 200 021 — 13813970

220 200 021 — 13813980

230 200 021 — 13813990

240 200 000 — 13814210

250 200 002 — 13814110

21

180 200 002 — 14469320

190 200 022 — 14469310

200 200 022 — 14469320

210 200 022 — 14469330

220 200 022 — 14469340

230 200 022 — 14469350

240 200 022 — 14469360

250 200 022 — 14469370

22

180 200 023 — 15124660

190 200 023 — 15124670

200 200 023 — 15124680

210 200 023 — 15124690

220 200 002 — 15124730

230 200 023 — 15124710

240 200 023 — 15124720

250 200 023 — 15124730

23

180 200 000 — 15782420

190 200 000 — 15782430

200 200 000 — 15782440

210 200 000 — 15782450

220 200 000 — 15782460

230 200 000 — 15782470

240 200 000 — 15782480

250 200 000 — 15782490

24

180 200 025 — 16435380

190 200 025 — 16435390

200 200 002 — 16435450

210 200 025 — 16435410

220 200 025 — 16435420

230 200 025 — 16435430

240 200 025 — 16435440

250 200 025 — 16435450

25

180 210 001 — 11858420

190 210 001 — 11858430

200 210 001 — 11858440

210 210 001 — 11858450

220 210 001 — 11858460

230 210 001 — 11858470

240 210 001 — 11858480

250 210 001 — 11858490

26

180 210 001 — 12595780

190 210 001 — 12595790

200 210 000 — 12515890

210 210 001 — 12595810

220 210 001 — 12595820

230 210 001 — 12595830

240 210 001 — 12595840

250 210 001 — 12595850

27

180 210 020 — 13161140

190 210 020 — 13161150

200 210 020 — 13161160

210 210 020 — 13161170

220 210 020 — 13161180

230 210 020 — 13161190

240 210 002 — 13161200

250 210 020 — 13161210

28

180 210 002 — 13816510

190 210 021 — 13816510

200 210 021 — 13816520

210 210 021 — 13816530

220 210 021 — 13816540

230 210 021 — 13816550

240 210 021 — 13816560

250 210 021 — 13816570

29

180 210 022 — 14471860

190 210 022 — 14471870

200 210 022 — 14471880

210 210 022 — 14471890

220 210 002 — 14471920

230 210 022 — 14471910

240 210 022 — 14471920

250 210 022 — 14471930

30

180 210 023 — 15127220

190 210 023 — 15127230

200 210 023 — 15127240

210 210 023 — 15127250

220 210 023 — 15127260

230 210 023 — 15127270

240 210 023 — 15127280

250 210 023 — 15127290

31

180 210 024 — 15782580

190 210 024 — 15782590

200 210 002 — 15782640

210 210 024 — 15782610

220 210 024 — 15782620

230 210 024 — 15782630

240 210 024 — 15782640

250 210 024 — 15782650

32

180 210 025 — 16437940

190 210 025 — 16437950

200 210 025 — 16437960

210 210 025 — 16437970

220 210 025 — 16437980

230 210 025 — 16437990

240 210 000 — 16438250

250 210 002 — 16438510

33

180 220 018 — 11852980

190 220 018 — 11852990

200 220 000 — 11853180

210 220 001 — 11853810

220 220 001 — 11853820

230 220 001 — 11853830

240 220 001 — 11853840

250 220 001 — 11853850

34

180 220 001 — 12598340

190 220 001 — 12598350

200 220 001 — 12598360

210 220 001 — 12598370

220 220 001 — 12598380

230 220 001 — 12598390

240 220 000 — 12518490

250 220 001 — 12598410

35

180 220 002 — 13163700

190 220 020 — 13163710

200 220 020 — 13163720

210 220 020 — 13163730

220 220 020 — 13163740

230 220 020 — 13163750

240 220 020 — 13163760

250 220 020 — 13163770

36

180 220 002 — 13819160

190 220 002 — 13819170

200 220 002 — 13819180

210 220 002 — 13819190

220 220 002 — 13819110

230 220 021 — 13819110

240 220 021 — 13819120

250 220 021 — 13819130

37

180 220 022 — 14474420

190 220 022 — 14474430

200 220 022 — 14474440

210 220 022 — 14474450

220 220 022 — 14474460

230 220 022 — 14474470

240 220 022 — 14474480

250 220 022 — 14474490

38

180 220 023 — 15129780

190 220 023 — 15129790

200 220 002 — 15129830

210 220 023 — 15129810

220 220 023 — 15129820

230 220 023 — 15129830

240 220 023 — 15129840

250 220 023 — 15129850

39

180 220 024 — 15785140

190 220 024 — 15785150

200 220 024 — 15785160

210 220 024 — 15785170

220 220 024 — 15785180

230 220 024 — 15785190

240 220 002 — 15785240

250 220 024 — 15785210

40

180 220 000 — 16442550

190 220 002 — 16445510

200 220 002 — 16445520

210 220 002 — 16445530

220 220 002 — 16445540

230 220 002 — 16445550

240 220 002 — 16445560

250 220 002 — 16445570

41

180 230 018 — 11855540

190 230 018 — 11855550

200 230 018 — 11855560

210 230 018 — 11855570

220 230 018 — 11855580

230 230 018 — 11855590

240 230 001 — 11855680

250 230 018 — 11855610

42

180 230 000 — 12511990

190 230 001 — 12519910

200 230 001 — 12519920

210 230 001 — 12519930

220 230 001 — 12519940

230 230 001 — 12519950

240 230 001 — 12519960

250 230 001 — 12519970

43

180 230 020 — 13166260

190 230 020 — 13166270

200 230 020 — 13166280

210 230 020 — 13166290

220 230 002 — 13166300

230 230 020 — 13166310

240 230 020 — 13166320

250 230 020 — 13166330

44

180 230 021 — 13821620

190 230 021 — 13821630

200 230 021 — 13821640

210 230 021 — 13821650

220 230 021 — 13821660

230 230 021 — 13821670

240 230 021 — 13821680

250 230 021 — 13821690

45

180 230 022 — 14476980

190 230 022 — 14476990

200 230 000 — 14477220

210 230 002 — 14477210

220 230 002 — 14477220

230 230 002 — 14477230

240 230 002 — 14477240

250 230 002 — 14477250

46

180 230 023 — 15132340

190 230 023 — 15132350

200 230 023 — 15132360

210 230 023 — 15132370

220 230 023 — 15132380

230 230 023 — 15132390

240 230 002 — 15132430

250 230 023 — 15132410

47

180 230 002 — 15787740

190 230 024 — 15787710

200 230 024 — 15787720

210 230 024 — 15787730

220 230 024 — 15787740

230 230 024 — 15787750

240 230 024 — 15787760

250 230 024 — 15787770

48

180 230 002 — 16443560

190 230 002 — 16443570

200 230 002 — 16443580

210 230 002 — 16443590

220 230 002 — 16443150

230 230 025 — 16443110

240 230 025 — 16443120

250 230 025 — 16443130

49

180 240 001 — 11858180

190 240 018 — 11858110

200 240 018 — 11858120

210 240 018 — 11858130

220 240 018 — 11858140

230 240 018 — 11858150

240 240 018 — 11858160

250 240 018 — 11858170

50

180 240 019 — 12513460

190 240 019 — 12513470

200 240 019 — 12513480

210 240 019 — 12513490

220 240 001 — 12513590

230 240 019 — 12513510

240 240 019 — 12513520

250 240 019 — 12513530

51

180 240 020 — 13168820

190 240 020 — 13168830

200 240 020 — 13168840

210 240 020 — 13168850

220 240 020 — 13168860

230 240 020 — 13168870

240 240 020 — 13168880

250 240 020 — 13168890

52

180 240 021 — 13824180

190 240 021 — 13824190

200 240 002 — 13824210

210 240 021 — 13824210

220 240 021 — 13824220

230 240 021 — 13824230

240 240 021 — 13824240

250 240 021 — 13824250

53

180 240 022 — 14479540

190 240 022 — 14479550

200 240 022 — 14479560

210 240 022 — 14479570

220 240 022 — 14479580

230 240 022 — 14479590

240 240 002 — 14479620

250 240 022 — 14479610

54

180 240 002 — 15134930

190 240 023 — 15134910

200 240 023 — 15134920

210 240 023 — 15134930

220 240 023 — 15134940

230 240 023 — 15134950

240 240 023 — 15134960

250 240 023 — 15134970

55

180 240 002 — 15794260

190 240 002 — 15794270

200 240 002 — 15794280

210 240 002 — 15794290

220 240 000 — 15792340

230 240 002 — 15794310

240 240 002 — 15794320

250 240 002 — 15794330

56

180 240 025 — 16445620

190 240 025 — 16445630

200 240 025 — 16445640

210 240 025 — 16445650

220 240 025 — 16445660

230 240 025 — 16445670

240 240 025 — 16445680

250 240 025 — 16445690

57

180 250 001 — 11868660

190 250 001 — 11868670

200 250 001 — 11868680

210 250 001 — 11868690

220 250 000 — 11861780

230 250 001 — 11868710

240 250 001 — 11868720

250 250 001 — 11868730

58

180 250 001 — 12516920

190 250 001 — 12516930

200 250 001 — 12516940

210 250 001 — 12516950

220 250 001 — 12516960

230 250 001 — 12516970

240 250 001 — 12516980

250 250 001 — 12516990

59

180 250 020 — 13171380

190 250 020 — 13171390

200 250 002 — 13171400

210 250 020 — 13171410

220 250 020 — 13171420

230 250 020 — 13171430

240 250 020 — 13171440

250 250 020 — 13171450

60

180 250 021 — 13826740

190 250 021 — 13826750

200 250 021 — 13826760

210 250 021 — 13826770

220 250 021 — 13826780

230 250 021 — 13826790

240 250 002 — 13826810

250 250 021 — 13826810

61

180 250 002 — 14482120

190 250 022 — 14482110

200 250 022 — 14482120

210 250 022 — 14482130

220 250 022 — 14482140

230 250 022 — 14482150

240 250 022 — 14482160

250 250 022 — 14482170

62

180 250 023 — 15137460

190 250 023 — 15137470

200 250 023 — 15137480

210 250 023 — 15137490

220 250 002 — 15137530

230 250 023 — 15137510

240 250 023 — 15137520

250 250 023 — 15137530

63

180 250 024 — 15792820

190 250 024 — 15792830

200 250 024 — 15792840

210 250 024 — 15792850

220 250 024 — 15792860

230 250 024 — 15792870

240 250 024 — 15792880

250 250 024 — 15792890

64

180 250 025 — 16448180

190 250 025 — 16448190

200 250 002 — 16448250

210 250 025 — 16448210

220 250 025 — 16448220

230 250 025 — 16448230

240 250 025 — 16448240

250 250 025 — 16448250

Color Chart

RGB colors with Their respective values in one sheet macro

witsonjoyet

Board Regular

Yongle

Well-known Member

Excel Facts

YasserKhalil

Well-known Member

Zenwood

Board Regular

Zenwood

Board Regular

DanteAmor

Well-known Member

Yongle

Well-known Member

witsonjoyet

Board Regular

DanteAmor

Well-known Member

Zenwood

Board Regular

Zenwood

Board Regular

Similar threads

Forum statistics

Share this page

RGB colors with Their respective values in one sheet macro

Board Regular

Well-known Member

Excel Facts

Well-known Member

Board Regular

Board Regular

Well-known Member

Well-known Member

Board Regular

Well-known Member

Board Regular

Board Regular

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock