I am currently using =COUNTIF($A$4:$A$1088, B3) to conditional highlight B3:AQ1000 for duplicate values found in A4:A1088. How would I make this highlight the reversal, as in all cells that are not duplicates of A4:A1088?
Have already tried =COUNTIF($A$4:$A$1088, "<>"&B3) and more and could use some help.
Have already tried =COUNTIF($A$4:$A$1088, "<>"&B3) and more and could use some help.