Select the option ‘Use a formula to determine which cells to format.’ This will allow you to insert a formula for a range of cells. Step 3) Select option ‘Use a formula to determine which cells to format’ Select the entire data, apply conditional formatting from the Home menu. And you want to highlight the bill amount for which delivery is not completed. ISBLANK function can be associated with conditional formatting to find blank cells and format the cells accordingly.Ĭonsider the following dataset that consists of data order_number, bill amount, delivery status.
Here the two orders are not completed the delivery rest are delivered.Īlso Check:- Excel Formulas & Functions: Learn with Basic EXAMPLES Example 3: How to use ISBLANK function with conditional formatting? This True/False is fed to the IF function that returns a ‘No’ if the cell is empty and statement ‘Complete’ if a value is present.Īfter applying the formula to the status of each order will get which are orders delivered and not delivered yet.the ISBLANK function will check the cell of delivery date, and according to the value, it will result in the true or false.The formula applied is =IF(ISBLANK(C2), "No", "Complete") If the cell is blank, it will return ‘No’ otherwise ‘Complete.’ IF function is used along with ISBLANK, to give result according to the two different conditions. To get the results in the way you want, have to use some another function along with ISBLANK. In the status column, you want to get the result as ‘complete’ for orders which are delivered and ‘No’ for which are not delivered. The data is given below with order numbers and delivery date. In the above example, the ISBLANK function result gives TRUE or FALSE. The delivery date which is true is the order not yet delivered.Įxample 2: How to use ISBLANK with different excel functions? For the orders ‘118531884, 126387159’ delivery date is not given and is an empty cell. To find the undelivered orders applying the formula to each cell. For the order ‘118531884’ delivery date is not given and the formula returns the result as ‘TRUE.’ You apply the same formula for the rest of the cells. So, the formula will be as given in the formula bar that is ‘ ISBLANK(C2)‘ where C2 refers to the delivery date of the first order.Īnd the value returned as ‘FALSE’ since the delivery date is given which is a non-empty cell. The format is ‘=ISBLANK(value)’ for the value you can select the column delivery date corresponding to each order numbers. So can apply the formula ISBLANK to find the blank cells in the column delivery_date. Here you can consider the orders which do not have a delivery date marked can be considered as not yet delivered.
Let’s find the orders which are not yet delivered. Order number and its delivery date are given. In following excel, given is the status of some orders. Where Value can be a cell reference Example 1 How to use ISBLANK? This is a simple function in excel, and the format is.