Formulas or code to find multiple entries and change corresponding cell values

Hello

I hope someone can help.

I'm trying to do the following:

A B C D

TEXT 1 DESCR 1 Superseded
TEXT 2 DESCR 1 Current
TEXT 1 DESCR 2 Current
TEXT 3 DESCR 1 Current

There are around 1500 rows and growing. New rows are entered at the bottom with text in column A and 'Current' in column D. I need to find previous identical entry in column A and change it's status in column D to 'Superseded' and ideally grey out entire row.

I would really appreciate your help.

Thank you very much

FWIW:

Please Login or Register  to view this content.

Hi

Thanks for sending this and sorry for late reply.

I still can't get my head around it. Tried the codes but nothing happens. The table looks like below. There are around 3000 entries there at the moment and the sheet is being updated in bulks so another few thousand rows will be added at the bottom from time to time. I need to find all rows with the same Document Number (A), for the last one with the highest Rev No change the status to Current Rev and all the previous ones above to Superseded and grey out all the superseded although that one is optional.

Capture.PNG

Do you have any more suggestions please?

Thanks a lot!
J