Conditional Formatting Between Two Sheets

If anybody can help me with this matter, that would be great.

I have attached a small version of my spreadsheet for you guys.

My boss has this project for me to do and I am running into a problem. I have quite a bit of experience using EXCEL, however, I am lacking in the conditional formatting department.

I have 2 sheets :
Sheet 1 contains data that corresponds to a Current Project
Sheet 2 is the Master Data Base

In sheet 1, I have Col E checking to see if C and D match in Master Data Base. If they match, I then need to check to see if a DJ# that is given in Col A of sheet 1 also matches. When the DJ# matches, I have it display "DJ# MATCH".

My boss would like....
If a final "DJ# MATCH" is seen (like in row 11 of sheet 1), she would like that data to be highlighted in the MASTER DATA BASE sheet. In other words, since DJ# MATCH is seen at the end of row 11 in sheet 1, it needs to highlight row 2 (its corresponding data) in sheet 2.

Is this possible and if so, can anybody help me. I have been working on this for hours and have made no progress.

Jamie

First, since you are using conditional formatting to look at values in another sheet, we need to create a named range.... so in the Current Project sheet, select the whole table from A1:F24 and in the Name Box to the left of the Formula Bar at the top, enter a name.. e.g CurrProject.

Then in Sheet2, remove the currect conditional formatting rule you created and then select C2:J8 and re-invoke conditional formatting with rule formula:

=INDEX(INDEX(CurrProject,0,6),MATCH($C2,INDEX(CurrProject,0,1),0))="DJ# MATCH"