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

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"
schrieb im Newsbeitrag
...
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

Thank you Erny!

"thebluefairyfactory" wrote:

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