Hi, apologies if this has been posted before but my searches have not provided a solution.

I am trying to create a conditional formatting rule that can establish the difference between 2 cells (e.g. Cell 1 = 50% / Cell 2 = 60%) so that if the difference is greater than 10% it goes red/green (if minus/plus).

The closest I can think of would be to create a "difference" cell, however I would like the conditional formatted colour to apply to the original cells.

Hope that made sense! Any help will be greatly appreciated as always!!

Thanks.