Question

Highlight values in excel based on a given list

Answer 1

Answer:

Use Excel conditional formatting to highlight items that are in a list on the worksheet.

Create a list of items you want to highlight. ...

Select range A2:A7.

On the Ribbon's Home tab, click Conditional Formatting, then click New Rule.

Click Use a Formula to Determine Which Cells to Format. ...

For the formula, enter.