Could you send me over an example document, it helps me understand what your looking at.
I can then give you some example formulas to help you with part B of your question.
With regard to part A, you can get the cell to change colour (highlight) when a condition (threshold) is met using the Conditional Formatting option. Select the cells you want to apply formatting to, then under 'home' tools bar, looking for conditional formatting, which on mine is found under the tools group Styles. From here you can then enter in a condition and when it is met, the format you define will be appplied to the cells (you can apply multiple conditions to one cell).
Thank you for the document, can you give me an example of what cell you want to show.
Eg. Cell P11 should look at the gross value in I11, compare to table in E1 to F9, then return the percentage (which is what you have done in the formula already)
If you provide you phone number I can give you a call.Please also navigate to here so we can screen share. http://www.justanswer.com/remotedesktop/join.aspx?Session=af9f715b-bcaf-4a79-a8ee-456a9ddedb51
Sure 1.30 is fine.
Further to our phone call, you can now set conditional formatting and identify the correct commission rate within your excel document.
Please let me know if I can be of any further assistance.