Is there a nice simple way to highlight a cell if the number contained in
that cell changes? I'm about to pull my hair out on this one... !

Here is my scenario: We track our sales on a spreadsheet. Sales reps enter
status of the sale in Column P (status being Sold, Lost Pending etc) and then
in Column M the sales rep enters a number related to how far along in the
sales process they are (i.e. 50%, 90% etc).

What I would like to have happen is that if there is a status change made to
any of the cells in that column, the cell would highlight. I have been able
to make the cells highlight based on percentage using conditional formatting
but I only want the cells to highlight if they have been changed during the
past week. I don't want my 25%'s to always be blue, etc. and I really don't
need to know if any other cells have changed so I don't want to use tracking.


Is this a pipe dream?
Thanks! Lauren