I haven't been able to find an answer yet to this issue, maybe someone can help:

I have an array of cells, let's call it A1:D5 for simplification. In each of these cells are various different 4-digit numbers (codes). I also have a short list of codes in a column F1:F5 that fit into a certain category that I'm looking into. My question is this:

How do I write a formula in conditional formatting that I can apply to the entire array A1:D5 that checks if the value of EACH INDIVIDUAL CELL in that array (A1:D5) contains a value that exists in F1:F5 and turns those cells blue if that condition is satisfied?

I can format each cell by itself using =Countif(F1:F5,A1)>0 for A1, but I want to apply this over the whole array A1:D5 all at once and have the condition apply to each cell by itself but not the whole array.

Thanks!