Conditional Formatting Excel Based On Text. Conditional formatting allows you to format a cell or a range of cells based on the value in it. Go to home tab conditional formatting new rule.
Select the color format for the text and click ok. To use conditional formatting based on another cell select new rule option from the home menu s conditional formatting dropdown. Conditional formatting allows you to format a cell or a range of cells based on the value in it.
Steps to highlight the cells if text contain a specific character select the complete table.
Use a formula to determine which cells to format. To use conditional formatting based on another cell select new rule option from the home menu s conditional formatting dropdown. Conditional formatting allows you to format a cell or a range of cells based on the value in it. Click the last option.
