Simple productivity tracker w/ some conditional formatting

Hello Excel Forum users! I'm trying to create a simple Excel workbook to track productivity in my department and am not sure of the best way to do this. There are about twenty different functions we track on a time sheet and each function has a 3 - 4 letter code and an expected production rate to go along with it. As you can see in the screenshots I've attached(uploader wasn't cooperating when trying to post the actual workbook) that I currently have two sheets going: The first sheet has employee names and dates for axes and then the cell has data in the format 'DSO, 101.47' (DSO is a code referring to a specific function and the number is the average lines per hour produced by the associate). The second sheet is a reference page that has listed all the codes and their corresponding rates. I'd like for it to look at a cell, reference the 'codes and rates' sheet to grab the expected rate, and then use some conditional formatting to show whether the associate was below or above rate for the week.

I'm fairly flexible as how this workbook could be laid out, so if there's a simpler way then I could try that instead.

-Thanks!

Productivity_Tracker.xlsx

with your format , i have used
=RIGHT(B2,(LEN(B2)-FIND(",",B2,1)))*1>=VLOOKUP(LEFT(B2,(FIND(",",B2,1)-1)),'Codes & Rates'!$B$1:$C$21,2,FALSE)
for equal to or greater than the reference

Now
this is extracting anything before the , - and using that as a code to lookup the reference sheet
LEFT(B2,(FIND(",",B2,1)-1))

then it extracts the text after the , to get a number
=RIGHT(B2,(LEN(B2)-FIND(",",B2,1)))*1
and as this is text * 1 to change to a number

if you change that layout at all - then it will not work
so must be a format with
code , number

uses a standard vlookup to lookup the code and return the value

in D2 - you see the formula to extract the code
in E2 - you see the formula to extract the value
in G2 - you see the formula combined in a vlookup to return false or true test on the value

your welcome, thanks for the rep