(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 of =$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, (see the second screenshot above): Click the 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 be blank with the Conditional Formatting command in Excel, you can do as following:ġ.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |