Paste the formula in the box below the Formula Rule Type. In the Conditional Formatting task pane to the right, select Formula from the Rule Type dropdown.In the Home tab, select Conditional Formatting and select New Rule.Next, we want to use the formula created to apply Conditional Formatting to our dataset. In addition, we applied mixed cell reference to cell D2 and C2 respectively by making the columns D and C to be absolute while row 2 remains relative cell references This is required in order not to allow the reference to move down when the formula is copied down. Note, we have applied absolute cell reference to H2 and I2:I6. We want to write the formula in column F before we copy the formula and perform the conditional formatting. For example, we have a small table in columns H and I respectively that contains the unique Cities and the Target. Our goal is to use XLOOKUP Function to format the entire rows that meet the criteria we are going to specify. In the screenshot below, we have Sales Data in the XLOOKUP and FILTER sheet tab. In this tutorial, we are going to learn how to use XLOOKUP & FILTER Functions to apply conditional formatting to our Sales Dataset.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |