Forum Discussion
Excel Formatting
I have number in column Y. If they are equal to any of the numbers in column C I would like to turn them both a color. I think my formula is only having it look at the specific row that the number ...
If to highlight you may use two conditional formatting rules. One with formula
=C2=$Y$2applied to the range C2:C3294.
Another one with
=COUNTIF($C$2:$C$3294, $Y$2)applied to Y2