![]() ![]() Go to the Fill tab, specify a background color, and click the OK button.ĥ. ![]() Now the Format Cells dialog box is opening. ![]() (3) If you want to highlight rows if cells begin with specific text, you need to enter =LEFT($B2,5)="Apple" or to highlight rows if cells end with specific text, enter =RIGHT($B2,5)="Apple".Ĥ. (2) If you want to highlight rows if cells are blank, enter =$B2="" in the Step 3-(2). And this formula can only find out cells only containing the specific text or value. (1) In the formula =$B2="Apple", $B2 is the cell you will check if contains the specific text or value, and "Apple" is the specific text, you can change them as you need. (2) In the Format values where this formula is true box, enter =$B2="Apple" (1) Click to select the Use a formula to determine which cells to format in the Select a Rule Type box In the coming New Formatting Rule dialog box as shown in the second screenshot above, please do as follows: Click Home > Conditional Formatting > New Rule. Select the purchase table without its column headings.Ģ. To highlight entire rows of cells containing the specific text, value or just blank cells with the Conditional Formatting command in Excel, you can do as following:ġ.
0 Comments
Leave a Reply. |