This is the simple dectector I’ve ever made a long time ago.
I hope this simple program can make you easy to detect a color code on certain site.
This exe file will show the RGB code directly from any site you want.
If you want to change the code to hex from dec, just use Calculator using scientific view on View menu.
Here is the screen shot of the program:
Click here to download or run
Sometimes we will see the unexpected relsult (######) sign in certain cell, (please see picture below).
To correct it, all we have to do is to adjust column width . In this case we just widened between column B and column C. So the correct result is below:
In this example I try to make an exercise the combination of HOUR and MINUTE.
In this case I use HOUR to get hour from the Diff. column and MINUTE from Diff. Column.
In Hour to minute column, we multiply Hour to 60 (=E4*60).
The formula in Total in minute is =HOUR(D4)*60+MINUTE(D4)
The formula in Grand Total is =H4*$E$2
I use $ for cell E2 to make absolute value
The output result is:
Choose the cell you want.
Use the menu option Data | Validation.
Click Input Message tab, type title you want in the title box then type the message in the input message.
Result: when you select that cell, it will show the title and the input message.
Right click on the name sheet that will be changed.
Choose Rename.
Type the new sheet name and press enter.
On the Insert menu, click Worksheet.
One sheet will be added in sheet tabs.
Create a drop-down list in Microsoft Excel is easy.
Along with this, I give you an example.
First, type the names below in the A column from cell A1 to cell A5:
Ari
John
Klark
Michael
Patric
I assume that we will create a drop-down list in cell C1.
The step that you should do:
On the Data menu, click Validation, and then click the Settings tab.
In the Allow box, click List.
Click the Source box and block cell A1 until A5 then clik Ok
See the result below:
To create an automatic data in Microsoft Excel is easy.
The advantage of using automatic data is we as a user, do not need type a routine words. For example, we have the list below:
Acapulco
Miami
Puerto Rico
San Francisco
San Juan
The step to create new list:
Click Tools
Click Options
Click Custom Lists tab
Click NEW LIST to create
The cursor will move to List Box Entries
Type the all cities name lists that we have
Don’t forget press ENTER after you type any city.
Click Add then click OK
To see the result, you just type Acapulco then move the mouse to the bottom on the right corner and it show plus sign.
After you click and drag you should see ..
So when we need those lists, we just type Acapulco then click & drag to show the rest of the words.
Exercise 1 (VLOOKUP)
Please type Table 2 in cell A8.
Type Number, City in cell A9, Age in cell B9 and Age in cell C9.
Fill in 1 to 4 under Number column.
Type Miami, Ketchikan, Seattle and Vancouver under City column.
Type 34, 61, 23 and 45 under Age column.
For Table 1
Please type Number, Name, City, Age start in cell A1,B1 and so forth.
Fill in 1 to 4 and name under Number and Name column.
Please use VLOOKUP function to fill City and Age column.
The output result is below:
So the formulas that we use:
=VLOOKUP(A3;$A$10:$C$13;2)
=VLOOKUP(A3;$A$10:$C$13;3)
To use function vlookup is simple, we just remember how many columns that we have.
column is counted from left to right.
don’t forget to use $ sign to make absolute value by pressing F4 from keyboard.
remember when we make a table for vlookup function, the columm key for lookup_value should be sorted ascendingly, otherwise we will see unexpected result.
if we see the picture that we have, so the correct formulas are:
=VLOOKUP(A2,$A$7:$B$9,2) for column B in cell B2
=VLOOKUP(A2,$A$7:$C$9,3) for column C in cell C2
Copy the formula to fill next row.