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.
Microsoft Excel “ISBLANK Function” is a Logical Function and it is used to check if cell in question is “BLANK OR NON-BLANK”. “ISBLANK Function” is used as a test to validate if cell contains any…
Use Excel’s DATE function when you need to take three separate values and combine them to form a date.
LOWER function is used for changing the format of any text or string to LOWER case.
This tutorial explains what an Excel name is and shows you how to define a name for a cell, range, constant, or formula. You’ll also learn how to edit, filter, and delete defined names in Excel.
Excel names are a bit of a paradox: they’re one of the most useful features, but many people find them unnecessary or too technical. That’s because few users truly understand what Excel names can do. This tutorial will not only teach you how to create a named range in Excel but also show you how this feature can make your formulas easier to write, read, and reuse.
In this post, you’ll learn how to Show formulas in Excel spreadsheets. Usually, when you create a formula in Excel, it shows the result in the cell. But sometimes, you might want to see the…
The only thing worse than wrong data in your spreadsheet is Empty Cells. If these blanks aren’t filled, they can cause problems when using formulas. I usually fill these empty cells with 0 or “NA”…