Trying to set up Conditional Formatting or other

Copper Contributor

I have two ALPHA columns in Excel
($b19:$b126) 
($b131:$b290)

I want to red-flag all cells in the first group that are equal to any cells in the second group.

I used to program a lot in Excel but that was a decade ago.

Thanks in advance for your help. 

2 Replies

@AllanMAllanMacRae 


If you create a conditional formatting for the first area with the following formula, it will work.

 

=COUNTIF(B$131:B$290,B19)>0

See also my example:

 

@dscheikey 

 

Great!!! Thank you!