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.
Create Dynamic Data Validation List When I started my career in working with excel dashboards, I always used to face most common challenge in “Data Validation” technique where I want a smart data validation to avoid all…
Pie Chart is one of the ways of visual presentation of your data sets. Sometimes it makes easier to understand the data while visualizing.
Have you ever got into situation in office where you need to count the cells in Excel sheet with specific color? If yes then you can use following code which counts the number of cells…
In Excel, a line break lets you finish one line of text and begin another within the same cell. It helps create separate lines of information without needing to move to a different cell.
How to Insert Symbol in Excel? Have you ever faced the challenge of using special character symbols in number formatting or customized number formatting? It is easy to insert any symbol in numbers i.e Delta…
To subtract numbers in Excel, follow these steps:
Start by typing an equal sign (=) in the cell where you want the result.
Enter the first number or cell reference you want to subtract from.
Type a minus sign (-).
Enter the second number or cell reference you want to subtract.