How to get RGB Codes of a Color

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.

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

2. Right click and select ‘Format Cells…’
3. In the Format Cells dialog box go to ‘Fill’ tab and click on ‘More Colors…’
4. That’s all, in the ‘Color’ dialog box, you can view the RGB (Red, Green, Blue) codes of the color

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

Author:
Excelsirji.com was started with the thought of making people experience easy while working with Excel, data analytics, vba, automations etc.
Comments

Leave a Reply

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

Are you a Data Enthusiast?

Join us for a ride on your data and automate your stuffs