Sort by duplicate numbers in rows and if contains specific text in specified column

Hi, i wonder if i can do this easy in excel or if i have to write a program to do this kind of calculations.

I need to find all the rows in a spreadsheet containing singel or duplicate values in column 1 with a specific text in column 34.
So, based on the text in col 34 all the other rows matching the first number i want to be filled with red.

For example, if row 1 and 2 is ok but not row 3, then all 3 rows will be filled with red, then if row 4 and column 1 is a new number it starts from there and so on to the final row

Thanks in advance!

Cool, looks like it could work, but i dont understand it exactly, is the code limited to 100 rows?, thanx for replying so fast

Hi again, i couldn't get the formula working correctly since it see everything that contains the specific text as true and doesn't seem to include the same number that doesn't have the specific text so im a bit lost, maybe i have to write a script instead that controls this :/

Ok, im at home right now so i dont have the correct excel program, only home starter here, but the logic is the same, i made an before and after sheet , thanx again for your patience

Hey, you're a genius it works great ) thanx a million!