Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting numbers and number formatting to a CSV file ? | Excel Worksheet Functions | |||
Automatic Formatting of Reports | Excel Discussion (Misc queries) | |||
Automatic formatting help? | Excel Discussion (Misc queries) | |||
Criteria - Automatic Change Font or Fill Colour | Excel Worksheet Functions | |||
Automatic Row Formatting | Excel Discussion (Misc queries) |