May 13 2024 10:22 AM - edited May 13 2024 10:23 AM
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.
May 13 2024 10:39 AM
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:
May 13 2024 12:58 PM