Show the Hex Color Code Format Option in Excel

Show the Hex Color Code Format Option in Excel

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.

Our Version of Excel

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
Show More Colors Options
  1. Click Home from the menu bar.
  2. From the Home ribbon, click either the paint bucket icon or font color icon.
  3. 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
  1. 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.


Training

Return to Homepage


Key Affiliates and Partners
PG Xtreme Teens
Excel Effects
Techronology