Johnny Thunder
Well-known Member
- Joined
- Apr 9, 2010
- Messages
- 693
- Office Version
- 2016
- Platform
- MacOS
Hi guys,
Just need someone to error check my code, it works for half of the syntax but leaving the first statement out?
Code:
"=AND(OR(D2<>$I$4,D2<>$I$5),ABS($E2)>0.01)"
So the code runs for the ABS(E2) portion, but seems to not care about the first D2 part.
I have two cells with values we know are not issues entered in I4 and I5, if the data in D2 does'nt equal either than highlight.
Any help on this is appreciated.
Just need someone to error check my code, it works for half of the syntax but leaving the first statement out?
Code:
"=AND(OR(D2<>$I$4,D2<>$I$5),ABS($E2)>0.01)"
So the code runs for the ABS(E2) portion, but seems to not care about the first D2 part.
I have two cells with values we know are not issues entered in I4 and I5, if the data in D2 does'nt equal either than highlight.
Any help on this is appreciated.