Hi,
I'm currently setting up some keyboard shortcuts via Macro to colour cells.
Is there a guide to which what colours are what number for coding? For example:
Thanks in advance![]()
.Color = 65535
![]()
Hi,
I'm currently setting up some keyboard shortcuts via Macro to colour cells.
Is there a guide to which what colours are what number for coding? For example:
Thanks in advance![]()
.Color = 65535
![]()
This might help:
http://www.endprod.com/colors/
(The 'MSAccess' column is the same index as Excel .color property)
Last edited by Speshul; 10-27-2014 at 08:45 AM.
You should hit F5, because chances are I've edited this post at least 5 times.
Example of Array Formulas
Click the * below on any post that helped you.
Or, a fun alternative,
Run this
Not sure how to sort it properly, I guess the color codes aren't particularly sequential by color
![]()
Sub Macro1() Application.ScreenUpdating = 0 For i = 1 To 100000000 Step 200000 Range("a1").Offset(y, 0).Select With Selection.Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic .Color = i - 1 .TintAndShade = 0 .PatternTintAndShade = 0 End With Range("B1").Offset(y, 0).Value = i - 1 y = y + 1 Next i Application.ScreenUpdating = 1 End Sub
Thank you![]()
FYI, they are RGB values ranging from RGB(0,0,0) to RGB(255,255,255) - i.e. 0 to 16,777,215.
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks