So i have a table of data see attached file for example of data:

Excel Forum Example.xlsx

The sheet is supposed to compare the data in the table to its relevant SOM bracket and then highlight with CF if the value exceeds the screening value.
What happens here is the SOM bracket on row 5 is calculated based on the figure in row 14.
After that what i want to do is condtionally format the data in range h7:k13. So to follow the data through for a specific example this is what i want to happen.

E.g. K7

The value is 14.1 and (following the same sample down) the SOM is 3.4. The correct SOM bracket for this data is 6% SOM. (i have already figured out the formula for this).
Going to the range c6:e6 we can then find the correct SOM and corresponding screening values. This should then imply the corresponding determinant for cell k7 is in cell e7.

I want excel to then decide 'is k7 greater than e7'. If it is then highlight it to the user.

I cannot wrap my brain around how to do this.. I feel like it may require a h or vlookup within a conditional format equation... but i may be wrong.

Does anyone have any ideas on this?

Regards,

Dan