Forum Discussion
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...
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:
