Highlight cells in an Excel column if the value can be found in an array

Question

If a cell's value can be found in columns B to E, can I highlight all of the cells in column A?

The value in column A should be highlighted whenever the same value is input in the arrangement.

Answer 1

Try this:

=COUNTIFS(B:E,$A1)