formula to highlight cell based on two variables

[Dena]

Attachment 377867

I am trying to to have a cell highlight if it matches another cell in a column on another tab and if another column contains specific data.

So far I have =ISERROR(MATCH(C4,Graduates,0))=FALSE and it works for only part of the problem

I want Tab 2014-2015, Column C to highlight in Green if the data in the cell matches any of the cells in column A on the Graduates tab (Graduates in my formula refers to a list which is column A) which it appears to be doing but I want the formula to go one step further. If the say C4 does match any of A2:A5000 I then want it to look at the Graduates tab, same row, column D (Major_Code) and if the same row says "0105-Registered Vet Technology", then I want C4 to highlight in Green. If the D column on the graduates tab does not say "0105-Registered Vet Technology", I want it to highlight in blue.

Any suggestions?

[FDibbins]

I have removed your attachment, I saw it contained personal data (email addy's). IT is never wise to include sensitive info in public forums

This will do it for you...
=INDEX(Graduates!$D$2:$D$244,MATCH(C4,Graduates,0))="0105-Registered Vet Technology"

A few points to consider...
1. CF works on TRUE/FALSE only, so there is no need to include ISERROR or =FALSE
2. CF can become very resource-heavy. I see that you have used it extensively, and your file is pretty slow now (not sure if thats the only reason)
consider reducing the range of your CF rules, they go down to row 5000, but your data barely goes past 500
3. consider using this in 2014-2015 Y2 down...
=IF(X4="","",IF(X4=0,"COMPLETED",IF(X4<4,"ALMOST","NO")))

[Dena]

Hello, this appeared to be working but a few names were highlighted when they didn't contain the "0105-Registered Vet Technology"

[Dena]

some names are listed more than once on the graduates list, I need the formula to look at all of the rows that contain the name and then check column D for the verbiage. If any of the rows with the individuals name says the verbiage, then highlight.

[FDibbins]

I dont have your file, and deleted your upload from here (sensitive info), so please put a dummy WB together, and upload again

[Dena]

Current RVT Students-tester.xlsx

Here is a file without personal data