Question: how to create a formula to highlight cells in excel?
Answer: 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. ...  Click the Format button. Select a font colour for highlighting.