Alex
Alex

Reputation: 1999

Excel Conditional Formatting Formula To Find Matching Cells

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

Upvotes: 0

Views: 79

Answers (1)

Harun24hr
Harun24hr

Reputation: 36870

Use formula like below.

=A2=A$1

See below screenshot.

enter image description here

Upvotes: 4

Related Questions