May 16 2022 12:10 PM
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 is in and I want to search the whole column.
Formula that I am using =IF(Y2="'C':C2:C3294",1,2)
Please let me know if you can help.
May 16 2022 12:22 PM
If to highlight you may use two conditional formatting rules. One with formula
=C2=$Y$2
applied to the range C2:C3294.
Another one with
=COUNTIF($C$2:$C$3294, $Y$2)
applied to Y2
May 16 2022 12:23 PM
May 16 2022 02:35 PM