Excel Tricks with Tejraj

In this post we will see how to highlight values which are less than specified value. We can do this by using Conditional Formatting. For this we will take an example. We have listed marks of 10 student in different subject in an excel sheet.  YouTube Video Now, we want to highlight the marks which are less than 40. But how?? Let’s follow below steps: 1. Select all the values from which we want to highlight the values which are less than 40. 2. Go to Home Tab --> Styles Group  -->  Select Conditional Formatting  -->  Select Highlight Cells Rules  -->  Select Less Than option 3. Less than window will appear as shown in below image. 4. Enter value 40 as we want to highlight values less than 40 in 1st input. 5. Select the formatting style from available drop down list in 2nd input. 6. Selected value and selected formatting style will be seen as shown in below image. Click OK. ...

If you are following my blog regularly, then till now you might aware that Cell is an area of intersection of row and column. But do you know how many total cells available in a single excel worksheet?  In the very first topic which I have posted on this blog titled as “ Introduction to Excel ”, I have mentioned that there are 16,384 columns and 10,48,576 rows available in excel sheet. So if we multiply no of columns to the no of rows then we will get the total no of cells. i.e. 16,384 x 10,48,576 = 17,17,98,69,184 cells are available in a single excel sheet. Now, important point to be considered here is that how we will come to know that exactly on which cell we are working? To know this we should be aware of cell address of each cell. This cell address will define exactly on which position we are working. This will help us when we will use various formulas. (We will cover excel formulas in our subsequent blog posts. Stay tuned for this!!!). So let’s see what are the...

In this post we will see how to highlight values greater than specified value with the help of Conditional Formatting. Conditional Formatting command is available in Home Tab under Style group. YouTube Video: For example, we have a listed random numbers from 10 to 99 in few cells and we want to highlight cells which have values greater than 50. Instead of highlighting these values manually, we will use conditional formatting. Just follow below steps: 1. Select all the values and then Select Conditional Formatting --> Highlight Cells Rules --> Greater Than 2. One window names as “Greater Than” will appear on screen. 3. Enter value “50” in first input as we want to highlight values greater than 50. And select the formatting style of your own choice in second input to highlight the resulted cells. 4. Here, we have selected our formatting style as “Green Fill with Dark Green Text” 5. The values which are greater than 50 are no...