Excel: Highlighted cells to modify another Cell

I have a long filtered sheet with aircraft data, each day more data comes in. All of this is filtered down to probably 50 items that are being monitored (Column K has a rule that only "Monitored", "Already Monitored" or "Fixed" can be put in with a pull down). The next day when data comes in several of those items that are monitored show up again. I have run a duplicate rule that highlights the items that are duplicated. What Im trying to do is have those cells that are highlighted (which happens to be Column L) make Column K change to "Already monitored". This needs to happen only to the new data so that the duplicate that was there already and was "Monitored" stays "Monitored" and the new duplicate will go to "Already Monitored". Im using Excel 2010 Thanks in advance for any suggestions

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of July 16, 2017.

For more resources for Microsoft Excel