reverse an existing conditional format formula to highlight the opposite data

Perodin

Board Regular
Joined
Sep 16, 2014
Messages
54
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.
 

Some videos you may like

Excel Facts

How to change case of text in Excel?
Use =UPPER() for upper case, =LOWER() for lower case, and =PROPER() for proper case. PROPER won't capitalize second c in Mccartney

AlphaFrog

MrExcel MVP
Joined
Sep 2, 2009
Messages
16,276
Try this...

=COUNTIF($A$4:$A$1088, B3)=0
or
=NOT(COUNTIF($A$4:$A$1088, B3))

Or if there are just the two conditions, give all the rows a default "No Duplicate" format and just use the "Duplicate" condition.
 
Last edited:

Perodin

Board Regular
Joined
Sep 16, 2014
Messages
54
Try this...

=COUNTIF($A$4:$A$1088, B3)=0
or
=NOT(COUNTIF($A$4:$A$1088, B3))

Or if there are just the two conditions, give all the rows a default "No Duplicate" format and just use the "Duplicate" condition.

The NOT function got it done, I forgot it even existed. Thank You
 

Watch MrExcel Video

Forum statistics

Threads
1,108,702
Messages
5,524,410
Members
409,575
Latest member
navarrov74

This Week's Hot Topics

Top