Question

The following image shows a formula (referring to cel Anh
highlighted cell should always show the value in cel At
value in the new cell A1, then the formula returns Pelicata
will you use so that the yellow highlighted cell always shows​

Answer 1

Explanation:

Highlight Items in a List

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.