I saw somewhere on the net a neat trick to determine the numeric color code using a leading question mark. Of course I've forgotten the routine. Any help?
I saw somewhere on the net a neat trick to determine the numeric color code using a leading question mark. Of course I've forgotten the routine. Any help?
.
.
One of many good resources.
http://dmcritchie.mvps.org/excel/colors.htm
Here's two macros to assist as well:
Please Login or Register to view this content.
Isn't the easiest way to select the cell in question, click Format Cells, Fill Tab, More Colours, Custom and read the RGB colour numbers?
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Isn't the easiest way to select the cell in question, click Format Cells, Fill Tab, More Colours, Custom and read the RGB colour numbers?
I like to use:
LewisPlease Login or Register to view this content.
Waaay to easy ! Let's use VBA !!!Isn't the easiest way to select the cell in question, click Format Cells, Fill Tab, More Colours, Custom and read the RGB colour numbers?
Select the cell that is formatted with the color you want to check.
Display the Home tab of the ribbon.
Click the down-arrow at the right side of the Fill Color tool, in the Font group. Excel displays a small palette of colors and some other options.
Choose More Colors. Excel displays the Colors dialog box.
Make sure the Custom tab is displayed
At the bottom of the dialog box you can see the individual values for the red, green, and blue components of the color in the cell.
Click OK when done.
Thank you all for your replies. But somewhere on the web I found a routine with a leading question mark that returned the rather unwieldy long number that represents shades of color in Excel. I don't remember whether it was in VBA or on the worksheet. It was pretty cool; but I haven't been able to find it again. Should've recorded it somewhere.
Please Login or Register to view this content.
LJM's suggestion works in the Immediate window, where the question mark is a shortcut for Debug.Print.
Entia non sunt multiplicanda sine necessitate
That's it. Thanks LJMetzger.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks