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.