Excel 2007 : Conditional Formatting: Delta Tracking

Experts,
I am working on a performance tracking excel spreadsheet that takes in a series of parameters for an application. What I am unsuccessfully trying to do is for every first instance delta in a given column based off the first data row I want to highlight the change.

The following is an example of what I mean.

Test Processors Memory Throughput
1 2 3 41
2 2 3 42
3 3 3 41
4 3 3 41


In this example I would want to see the Throughput value in test 2 highlighted, the processors and throughput highlight in test 3 and nothing highlighted in test 4 as the values between test 3 and test 4 did not change.

I'm using excel 2007 and have been playing with this unsuccessfully for the past while and I would sincerely appreciate any help.

Thank you in advance,
Daniel

Not sure if this is what you mean, but if that data is in A1:D5, then select D3:D5 and go to Home|Conditional Formatting, New Rule

Then select Format only cells that contain from top section.

Then select not equal to from 2nd drop down and enter =D2 in last field.

Then click Format and choose from Fill tab.

Then click Ok... click Ok again to finish.

The solution I posted highlights the cell if it is different than the previous, not the first.

If this is still not what you want, then can you post a sample workbook showing what you want highlighted and why.

Apply the same principal to each column selecting from row 3 down and then the conditional formatting rules as previously mentioned.

See attached... I removed all your manual formatting...

The sample I attached was a replica of your sample with expected results... and it had the conditional formulas in them... so not sure how it is not getting what you wanted... it was highlighting cells where the cell above was not the same value... i.e. highlighting when a change in value occurred within the individual columns....

No the solution I gave is not static on B2... it is on previous Cell... that is the way the formula is entered, but since I told you to select a range like B3:B5, then the formula will become relative... i.e. in B3 the reference is to B2, but in B4 the reference is to B3, and in B5, the reference is to B4...

Did you see my attachment? Was it wrong?

Do me a favour and open my attachment, go to C9 and type 4G ... do you not get any new colouring at that point and below?

Ok great... I was getting confused as to why you thought it wasn't working... glad it is resolved

Conditional Formatting.. especially on post XL2003 versions, is a bit confusing to audit because of the way it displays the applied formula no matter what cell you select. It still messes me up sometimes.

In XL2003 and previous, if you selected a different cell and checked the conditional formatting.. you will see that the reference does change.