Don't use the IF function. In Conditional Formatting, it is implied that we
are looking for a formula that evaluates to TRUE.

Try this:

=AND($K$2$U$2*0.8,$K$2<$U$2*1.2)

Also, the SUM functions are redundant since you only have one argument
inside of them.

HTH,
Elkar


"Rominall" wrote:

I have this formula that works in excel.
=IF(AND($K$2(SUM($U$2*0.8)),$K$2<(SUM($U$2*1.2))) ,"true","false")

And when I try to get it as conditional formatting I get the "not enough or
too many parenthesis" error.

This is what I tried in onditional formatting.
=if(and($k$2<(sum($u$2*.8)),$k$2(Sum($u$2*1.2)))) .

What am I doing wrong or can I not us the and function in conditional
formatting?

BTW, this is the 3rd criteria so don't tell me to split it up (the first two
are between functions)