HOW TO: Highlight cell if number in cell changes

[Guest]

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

 

[Erny]

If the sheet is less than half of the columns used, then one way could be to
copy the area of the sheet where you want to highlight the changes to a
protected area of the same sheet by using >Paste Special >Values, and then
using "Conditional formatting to detect the changes. This way would allow
you to use a relatively simple method to each week update the information
whenever you want.

Of course this will only work if you have not already used conditional
formatting for other purposes on the real cells, otherwise if these formulas
differ from cell to cell it could become complecated. But whatever you will
do, you will need a set of reference data to be able to compare.

Maybe VBA could also be considered, but I am less familiar with this.

Kind regards,
Erny


"thebluefairyfactory" <[email protected]>
schrieb im Newsbeitrag
news:[email protected]...

 

[Guest]

Thank you Erny!