Show the hex color code format option in Excel. On most websites and in web programming, you use hex values to apply colors to various items.
For example, the hex color code for RGB values 68, 114, 196 is #4472C4. Hex color code values typically begin with a pound (#) symbol.
All in all, we got lucky finding this feature in Excel.
While working on a project, we opened the color options dialog box and noticed something. It had an option to change or retrieve the hex color code for the selected item.
Our Version of Excel
Currently, we use Microsoft Excel 2016. In addition, we also work in Office 365. However, we first came along this feature in Excel 2016.
In case you are interested, below is the version information of our Excel app. Hopefully, you have the same or better.
Steps to Show the Hex Color Code in Excel
For the purpose of this quick tip, we use Microsoft Excel 2016.
Follow the steps below to show the hex color code for a certain element in Excel. Now, it may not be available in your version of Excel.
The Steps
Step 1: Show More Colors Options
- Click Home from the menu bar.
- From the Home ribbon, click either the paint bucket icon or font color icon.
- Under the paint bucket icon or the font color icon, click More Colors.
Step 2: Set or Get the Hex Color Code
- Set or get the hex color code. And, click OK or press Enter.
Success!
That is all to it. Again, keep in mind, not all Excel versions have this option in the colors dialog box.
The Workaround
If you do not have this option, then you can use a web tool to convert from RGB to hex or vice versa. Below, are some websites you can try.
Visual Basic Fix
Some websites provide a fix with Visual Basic code that you can put directly into Excel. See below.
