I have created a list on our new company sharepoint to track monthly sales orders, a kind of very basic sales pipeline if you will.
In our list we have "Sales Price" and "Cost Price" columns and from that, i am using two calculated columns to show "Profit" and "Margin" (as a %).
What i am looking to do, is colour code the "Margin" column as per the example below.
The code i am using to calculate the margin column is:
Thanks in advance :D