Conditinal Formatting Question - Have formula, just need to combine

[Johnny Thunder]

Hi guys, I am working on a notfication via conditional formatting and needed help combining a formula for conditional formatting


Is it possible to write the below as one statement?

=AND($D2<>"",ISNA(VLOOKUP($D2,$I$4:$I$5,1,FALSE)))
=ABS($E2)>0.01

Individually these formulas work but I need to have it be one statement.

With the new formula, if it is possible, I will be able to update the changes to this.

With ws.Range("A2:E" & Finalrow) 'The Conditional Formatting Lines
    .FormatConditions.Delete
    .FormatConditions.Add Type:=xlExpression, Formula1:="=AND(OR(D2<>$I$4,D2<>$I$5),ABS($E2)>0.01)" '<------ Update will go here
    .FormatConditions(1).Interior.Color = RGB(255, 255, 0)
    .FormatConditions(1).Font.Color = RGB(255, 0, 0)
    
    End With

 

[Joyner]

Hello, I'm not real clear on what you want to do, is the ABS, another condition that must be true for your conditional formatting? If so that just add it as another AND argument:

=AND($D2<>"",ISNA(VLOOKUP($D2,$I$4:$I$5,1,FALSE)),ABS($E2)>0.01)