Hi,

Probably a bit basic, but need some help.

I want a conditional formatting formula to do the following essentially:

If a value in Column I is > than +10,000 or < -10,000 And the value in Column J is > than 15% or < -15%, then turn the cell conditional formatting targeted cell yellow.

Essentially i have a nominal value of change/movement in Column I, and the % change in Column J.

And want the conditional formatting cell to turn yellow if the nominal movement is >15k or <-15K and the % change is > 15% or <-15%.

Any help appreciated!