in conditional formatting the function will return true or false - so you dont need to show that IF with a TRUE FALSE result.

=OR(K5>100000,K5<-100000), AND(OR(M5>10%,M5<-10%))). as you have an OR () which is complete - so the , after will not be understood hence , why a * may have been applied

BUT missing a function , not making sense as a function

Not sure what you exactly want

as you have a nested OR In and AND - BUT only an OR

do you want

AND ( OR(K5>100000,K5<-100000) , OR(M5>10%,M5<-10%) )

so evaluate from within

If K5 is greater than 100,000 __OR__ less than -100,000 - BUT nothing in between -100,000 and + 100,000

is that what you want for K5

so either of those must be TRUE

same for M5

M5 is greater than 10% __OR__ less than -10% - BUT nothing in between -10% and + 10%

so either of those must be TRUE

In order for the AND to have both the ORs must be true

to return a TRUE for conditional formatting to work]