Condional Formatting...maybe

Hello All!!!

I have come across an impasse and would like some help getting through it. In short, I have 3 sheets, 2 of which are relevant to this issue. On sheet HS, I have about 7000 lines. among the 8 or 9 columns, two are of interest. One column has an "Account number" the other has an Employee that is assigned to that account. the account number repeats itself everytime a job has been entered along with the employee who is over that job at the time.

On sheet TD I have a list of all the account numbers in one column along with the CURRENT employee who is over this account.

What I am wanting to do is determine if the CURRENT employee for an account differs from the HS sheet. Meaning did this account change hands over the period of time of my data, if so highlight that account.

This is just step one of my idea...next I would like to copy this entire line (if highlighted) and place on a new sheet. but I guess I can cross that bridge when I get there.

Attached is an example of what I have, then what I am looking for.

Thanks
BD

Conditional Example.xlsx

In your sample, A.Smith does not change accounts but is highlighted? Or am I missing something.

Originally Posted by JOHN H. DAVIS

In your sample, A.Smith does not change accounts but is highlighted? Or am I missing something.

Walmart had changed hands ( from K.Jones to A.Smith) I am looking for the account changing, not employee.


Souls,

So you are not reading anything from the TD Sheet are you? Just assuming that the first three entries on HS are current? in my real data this is not the case and is why I have the TD sheet...unless I am missing something

seems really close though

ok I see, you have to be on that sheet when running the macro. Well now that I know it works as intended....I am running into an issue with the difference in my example and my real data. the R1C1 selection is confusing me (as always) in my real data, the columns in HS are actually Employee = C:C account = I:I and TD are employee = B:B and Account = D:D. I tried to adjust them in the code as I always do, but after a few attempts got frustrated and called it quits ha.

thanks again

this should give you the idea

Conditional Example.xlsx

aahhh I was so close....noted and thanks for the help....I should be able to figure out the movement of all these to another sheet

thanks again
BD

well I jumped the gun on this....when I get to this line

Please Login or Register  to view this content.

I get a runtime error '91': Object variable or With Block variable not set

??

LIst of real.xlsm


the macro "worked" meaning no errors, but didn't highlight anything...I know that's not the real case...

gah...I suck ha.

ok. on Sheet1 I would like to highlight the Rig Number IF the Superintendent in the hole section data sheet is different on any row that what is shown in Sheet1 superintendent.

on what I called the column names, I was just doing that to try to simplify it...I think I ended up confusing myself, along with you ha

were you able to come up with something Solus?

that is correct

NICE....seems to be working as inteneded . again thanks for all your help and sorry for the confusion!!

Thanks BD

I hate to bring this back up, but I see no sense in creating a new post as it pretty much the same question. I am trying to run this code and, but instead of using the two sheets that's in the example above, I am using two of the "Sheet1" sheets to compare to each other. I figured this would be as easy as changing the sheet names, and adjusting the columns...when I run the code below, it goes to the first IF, then jumps to the end.

Please Login or Register  to view this content.

I hate to bring this back up, but I see no sense in creating a new post as it pretty much the same question. I am trying to run this code and, but instead of using the two sheets that's in the example above, I am using two of the "Sheet1" sheets to compare to each other. I figured this would be as easy as changing the sheet names, and adjusting the columns...when I run the code below, it goes to the first IF, then jumps to the end.

Please Login or Register  to view this content.

any ideas?