Highlight Changes without Tracking?

  • Thread starter Thread starter SGM
  • Start date Start date
S

SGM

Hi,

I've successfully used conditional formatting to compare
different values in cells between columns - that works
great with applying colors, etc. My next step is to be
able to highlight a cell if someone makes an edit without
using Tracking Changes. I don't think that I can get
conditional formatting to determine if a cell had changed
after someone changed it?
Can anyone verify if this is true?

My only other thought is to enable a certain format for
text color, or font that would apply for edits when
someone opens the workbook - any thoughts on being able
to do that?

Thanks!
 
Hi
you'll need VBA for this. e.g. an event procedure. But if the user
disables macros this won't work
 
Wow...2nd time this week someone reads my mind before I
post...similar question:
I have an 18 page price list that we use as a database to
print ONE price sticker to use on our product display.

When we change prices we only change about 50 out of 800
products. I would like to make the changes and then sort
the data so that the changed products are sorted all
together. this will enable me to print price sticker
labels for just the changed products without wasting label
stock. One printed I will re-sort the price list back
into the original order.

Is there any way that I can have a flag added to a record,
in a new column? I wil lthen use that flag to sort the
changes all together.

Thanks muchly!
 
Back
Top