Normally we shade color in cell by using fill color tool. If your cells are filled with numbers, you can distinguish the numbers and the number range by shading different color in each cell. But it is hard work to do them one by one if you have more cells to do. The Conditional Formatting is one of the Excel’s tools in order to help you adding color vary with the numbers you input. Let you follow the example below and get ”how to use the Conditional Formatting tool?”.
continue reading "Shading cell color vary with the objective number"

How to find the maximum or highest number in the Excel sheet ? 

For the Microsoft Excel. If you have many numbers or values and you must place the highest value in a cell, you will feel dizzy to find the highest value for that cell. Because of too many number, the Microsoft Excel supplies you the MAX Function for your convenience. The syntax of the MAX Function is
continue reading "Find Highest number by using MAX Function"