I am trying to create a conditional formatting formula between two columns. In one column I am trying to have all numbers above 10 highlighted, and in other the column all numbers over 120 highlighted. This is the formula I am using: =IF(AND($T3>=10,$V3>=120),TRUE,FALSE)
It is being weird and highlighting cells that don't fit the criteria and ignoring some cells that do (It is also not working when I plug in new column numbers?) I'm not sure what is wrong, I thought my formula was correct?
Also random side note, Is there a way to able this formula to multiple columns that have the same name without having to make a formula for each column number (ex.$A3)and instead the name of the column in the formula? Any help is appreciated! Thanks!
Recent Questions...
ما را در سایت Recent Questions دنبال میکنید
برچسب:
نویسنده: استخدام کار
بازدید: 307
تاريخ: پنجشنبه
14 مرداد
1395 ساعت: 5:33