0
votes

I have an array of numbers. How do I use conditional formatting to highlight the cells that have the same value as the first cell in that column? This is an example of what I want it to look like:

Example of cells

1

1 Answers

4
votes

Use formula like below.

=A2=A$1

See below screenshot.

enter image description here