Conditional Formatting Formula

[Tennisguuy]

I wanted to use conditional formatting to turn a cell red if a certain condition was true. The formula I wanted to use was a double lookup so I test the formula in an actual cell to see if it was working the way I wanted. Below is the formula

IF(OR(B57="OR",B57="TX"),VLOOKUP(VLOOKUP(B57,SOV!BN6:BO205,2,FALSE),SOV!BO6:BQ205,3,FALSE)) the formula worked and return a value of 35 which is correct.

The problem is when I tried to modify the formula to be based on a condition of the result I am getting a formula error. I tried different variations but I wanted formula to be true if the result was greater than 40. I tried the following in a cell to see if it would work

IF(OR(B57="OR",B57="TX"),VLOOKUP(VLOOKUP(B57,SOV!BN6:BO205,2,FALSE),SOV!BO6:BQ205,3,FALSE))>0.4. I know this is not correct because it says TRUE in the cell but it should be false because the value is 35.

I also tried this IF(AND(OR(B57="OR",B57="tx"),(VLOOKUP(VLOOKUP(B57,SOV!BN6:BO205,2,FALSE),SOV!BO6:BQ205,3,FALSE)))>0.4 but that didn't work either

 

[Fluff]

You're welcome & thanks for the feedback