![]() Just Replace the inserting formula in Edit the Rule Description with the following formula. Step 1: Repeat the Steps 1 to 4 from Method 1. We can use the OR function to achieve the desired result. In this case, we want rows to be formatted which have any of the entries such as “East”, “Boston”, “Crackers”, and “Whole Wheat” in the text value columns. Now, we want to take the conditional formatting a step further. Read more: How to Change a Row Color Based on a Text Value in a Cell in Excel Method 2: Using OR Function If you look closely, you can see the formula conditional formats only the rows that have both “East” as Region and “Bars” as Category. Again, Click OK.Īll the matching rows in the dataset get formatted with the fill color we selected. ![]() Step 4: You’ll return to the New Formatting Rule dialog box. From the Format Cells window, Choose any Fill Color from the Fill section. And the formula formats the rows for which these two arguments are True.
0 Comments
Leave a Reply. |