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.
Bookmarks