Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
colors
Is there an easy way to find out which background colors equal wha
numbers -- Message posted from http://www.ExcelForum.com |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
colors
Nevermind,
I just saw the thread started by Hari that has four examples of what wanted. i admit my mistake and my stupidity. For the records, i lik the second example given the best. That was nice. i like how it lai it out horizontally, and then put the number right in there. super job -- Message posted from http://www.ExcelForum.com |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
colors
No, because in theory, every workbook has its own color palette which can be
modified by the user. So a ColorIndex of 3 may represent a different color in different workbooks. Having said that, most users don't modify the default palette. This macro will help you to see what ColorIndex represents what color in your workbook: Sub ShowColors() Dim i As Integer For i = 1 To 56 With Cells(i, 1) .Value = i .Interior.ColorIndex = i End With Next End Sub -- Vasant "scottnshelly " wrote in message ... Is there an easy way to find out which background colors equal what numbers? --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
All colors in Office documents are grayscale, how do I see colors | Excel Discussion (Misc queries) | |||
Used drawing colors in shapes....lost default colors for "Fill Col | Excel Discussion (Misc queries) | |||
Worksheet formatting (fill colors & text colors) disappeared | Excel Discussion (Misc queries) | |||
Lost highlighting and font colors; background colors on web pages | Excel Discussion (Misc queries) | |||
Can't format font colors or cell fill-in colors | Excel Discussion (Misc queries) |