-
Pingback: ExcelSirJi | VBA TRICKS | VBA Code to Change Sheet Tab Color
-
Pingback: VBA Code to Change Cell Color | ExcelSirJi
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.

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.