PDA

View Full Version : Compares different rectangular areas and highlights equal values



RIC63
05-30-2016, 12:23 AM
I would like assign a colour to every cells in area1, 2, 3 and 4 that matches every value found in areaX and areaY, so for example looking at the value 47 which it is present in areaX... correspondence in area 1,2, 3 and 4 will be filled with a specific color ...and so on for every other value of area X & Y; see attached sample.

thanks for any suggestions

snb
05-30-2016, 12:32 AM
Use conditional formatting.


=countif($J$54:$N$65;D2)>0