Find Negative Values

[partyrental]

Hi

I have a set of data, in column D i have values both negative and positive, I am looking for a Macro that can change all the negative values in Col D to 1. So for example -20 would become 1.

Also i would like the macro to also highlight the whole row based on duplicate data in Col B

Please see screenshot for sample data
Untitled picture.png

[davsth]

Are the values in column D calculated or just values? if calculated max(calculation, 1) would do the first part

2nd question, do you want both rows highlighted or just the 2nd row when it is a duplicate? eg 2 and 3 or just 3?

[jindon]

Try

Please Login or Register  to view this content.

[partyrental]

They are just Values.

2nd Question: I would like both rows to be highlighted

Thank you

[jindon]

Please Login or Register  to view this content.

[partyrental]

Thank you this worked perfectly