Lesson#147: How to get color code in Excel

Hello friends! How are you? Just working on a simple thing. I was making some easy formulas to get color code in Excel. Just like if you color a cell then this formula will break the R, G, and B values of the color.

Here is how you can make formulas to get color code in Excel.

First of all, I am going to insert a button from Developer Tab in the sheet. Then I will assign a simple macro to this button to get the decimal color code of any cell. For this, I will designate a cell to get the value. Here I will designate the cell C5.

Now I will extract the values of Red, Green, and Blue from the decimal color code.

Before that, I want to let you know how we get the decimal color code from Red, Green, and Blue values. The formula is,

[RED] + [GREEN] * 256 + [BLUE] * 256 ^ 2

Now I will extract the value of RED with this formula in cell C2.

=MOD(C5,256)

Now in cell C3, I will extract the value of Green.

=MOD(C5-C2,256^2)/256

And in cell C4, I will extract the value of Blue with this formula.

=(C5-C2-C3*256)/256^2

I can easily make a Hexadecimal color code from these three values.

="#"&DEC2HEX(C2,2)&DEC2HEX(C3,2)&DEC2HEX(C4,2)

That will be easier to create the RGB color code.

="RGB("&C2&","&C3&","&C4&")"

That is how to get color code in Excel very easily. Here I am sharing the .xlsm file with you.