How do I format a cell if another cell contains text?

by

To highlight cells where the cell contains specific text found in another cell, we can use a formula in conditional formatting.

  1. Select the range to apply the formatting to (e.g. B3:E11).
  2. On the ribbon, select Home > Conditional Formatting > New Rule.

Can you conditionally format a cell based on another cell?

If you want to format a cell based on the value of another cell, for example to format a report row based on a single column value, you can use the conditional formatting feature to create a shape formula.

How to perform conditional formatting when cell contains partial text in Excel?

Select the text list you want to highlight the cells which contains partial text, and click Home > Conditional Formatting > New Rule, see screenshot: 2.

How to create a ruler in Excel from another cell?

In the same way, you can create a conditional formatting rule to compare the values ​​of two cells. For example: =$A2 $B2 formats cells or rows when a value in column A is less than the corresponding value in column B. =$A2=$B2 formats cells or rows when values ​​in columns A and B are the same.