Highlight latest entry in a workbook

**wacky213** · 11-04-2012, 07:09 PM

We have a list that gets updated every couple of days, currently we manually highlight the latest entry to show that its the new. And when a new entry is added we manually unhighlight the "old new entry" and highlight the new entry. I was hoping there was a way to make this process automatically. I was thinking conditional formatting or maybe a script i can run. Thanks in advance.

**TMS** · 11-04-2012, 07:26 PM

I would suggest you upload a sample workbook.

I take it the latest entry is not necessarily the last entry. If that's the case, how do you identify the latest entry? When it gets updated (every couple of days), does that mean one new row is added? Or several rows?

Maybe some more clarification around the process and the data would prove useful.

Regards, TMS

**wacky213** · 11-04-2012, 08:30 PM

Thanks for the quick reply.

We update the worksheet whenever a customer needs to be added. And no the latest entry is not necessary the last entry. It really depends on which column it needs to go. In the sample the new customer is Statoil, highlighted in red, and when a new customer gets added i will manually unhighlight statoil and highlight which ever the new customer is, for example Halliburton.

Hopefully this clears up my question a bit. Again, I really appreciate the help.

**TMS** · 11-04-2012, 08:57 PM

There doesn't seem to be an awful lot of logic in the process.

Still, it's doable with a worksheet change event. Unfortunately, I'm not near a computer at the moment.

In brief, when any cell changes, you need to clear the interior colour of ALL the cells. Then you change the colour of the Target cell.

It's two lines of code but I can't think of the syntax.

Something like:

Please Login or Register  to view this content.

You can record a macro to check the syntax and colour indexes.

Regards, TMS

**wacky213** · 11-05-2012, 08:33 PM

Okay I'm a complete noob when talking about scripts but i will try to make it work with the information given. At least now i now that it's possible. Thanks again.