How to Get RGB Codes of a Color?

Excel supports more than 16 million colors in a cell; hence you should know how to set the exact color in a cell. To do this through VBA, you can use RGB (Red, Green, Blue) function to set the color of a cell. The function requires 3 numbers from 0 to 255 [e.g. RGB(234,232,98)]. Below are the steps you can follow to get the RGB codes of your favorite color.

How to Get RGB Codes of a color

1. Select the cell which contain the color you want:

How to Get RGB Codes of a color

2. Right click and select ‘Format Cells…’

Get RGB Code in Excel

3. In the Format Cells dialog box go to ‘Fill’ tab and click on ‘More Colors…’

Get RGB number in Excel

4. That’s all, in the ‘Color’ dialog box, you can view the RGB (Red, Green, Blue) codes of the color

RGB Code

So here you can use the RGB code for your various purposes while preparing a dashboard i.e. Conditional formatting, VBA programming, Formulas etc.

Recommended Articles

Similar Posts

Leave a Reply

Your email address will not be published. Required fields are marked *