Highlight Like Values

  • Thread starter Thread starter Brandon G.
  • Start date Start date
B

Brandon G.

lets say I have the following info

A1 A2
1 5
2 6
3 7
4 8
5 9

I want to tell excel to highlight any numbers in column A2 that are
repeats from column A1...in this case only 5 would be highlighted?

Any thoughts?

Brandon
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scrabble Value calculation for Welsh words 0
Vlookup with If condition 1
adding values if the same - SUMIF in range of cells? 4
highlighting duplicate values 2
Is there a shorten way to increase the value 1
Ignoring highlighted cells 14
counts repeated number in two seperate area 1
Permutations 2

Back
Top