hello everyone,
here is my problem. I'm trying to turn any cell red that appears more than
once in a specifed column range. The problem is my cells have unique data in
them for example: John Beeman,1st,B1,Encapsulate. This data is all Indexed
and match from other sheets.
I tried going down the path of using
=countif($n$39:$n4$8,LEFT(n39,3)1 but nothing shades red.
Any help on this, please please.