Conditional Formatting
 

I've inherited a spreadsheet that I feel needs to be modified slightly so
that the information that I have to input is minimal. So here is my question:

I have 2 values that cross-sect in a graph. I need a value from the graph
placed into the third column and then color coded.

Can someone help me out? I'd really appreciate it.