Percentage Difference Calculator Formula

Hello, Just wondering if there was a way of getting percentage differences for two numbers using a forumula and then that showing as Red if under 100% or Green if over 100%, this will calculating for each row so for example

Main: Shop | Oranges % | Apples %
Oranges | Actual | Target | % of Actual vs Target (Oranges %)
Apples | Actual | Target | % of Apples Actual vs Target (Apples %)

Hi Jordan,

You should better formulate your request and include screenshots as it is not really clear.

As far as color-coding a cell/row based on its data, see

Want to get rid of the formula column? and write formulas that support multiple lines, variables and can update various columns at once? Take a look at the Advanced Formula Booster at*