Forum Discussion
AllanMAllanMacRae
May 13, 2024Copper Contributor
Trying to set up Conditional Formatting or other
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
- dscheikeyBronze Contributor
If you create a conditional formatting for the first area with the following formula, it will work.=COUNTIF(B$131:B$290,B19)>0See also my example:
- AllanMAllanMacRaeCopper Contributor