Forum Discussion
Hightlight based on duplicates AND a certain value
Hi, I have a spreadsheet which has duplicated values in column B. I want excel to look at the duplicates in column b and then for rows which have the same, duplicated entry in column B. I want it to...
HansVogelaarThis is great thanks, I was almost there with it but not quite. Unfortunately the file has 328000 rows and and this this is too much for it. It crashes when I try and put the formular in. Thanks for your help anyway.
If you're willing to use a helper column, that should avoid crashing.
Enter the formula in a free cell in row 1. I'll use G1 as example, but any other column is fine too.
=AND(COUNTIF($B$1:$B$32800,$B1)>1,COUNTIFS($B$1:$B$32800,$B1,$F$1:$F$32800,1154798451)>0)
Change the ranges if necessary, then fill down to row 32800 (or to the end of the data).
Create a conditional formatting rule as in my previous reply, but with the formula
=$G1