ExcelBanter - Highlight Like Values

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Highlight Like Values (https://www.excelbanter.com/excel-worksheet-functions/168831-highlight-like-values.html)

Brandon G.

Highlight Like Values

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

Teethless mama

Highlight Like Values

Conditional Formatting:

=COUNTIF($A$1:$A$5,$B1)0

format any color you like

"Brandon G." wrote:

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

All times are GMT +1. The time now is 05:50 AM.