Conditional Formatting Excel Based On Text. Use a formula to determine which cells to format. Select the color format for the text and click ok.
Then select the last option which is use a formula to determine which cells to format from the list. Click home conditional formatting highlight cells rules text that contains. When we want to format a cell based on the value in a different cell we will use a formula to define the conditional formatting rule.
A dialog box as shown in the picture below will open.
Excel conditional formatting based on another cell text 5 ways highlighting cells based on another cell text with formula. Use a formula to determine which cells to format. But sometimes instead of just getting the cell highlighted you may want to highlight the entire row or column based on the value in one cell. Conditional formatting in excel can be used in various ways.
