Conditional formatting OR statement

scottb
4StarLounger
Posts: 402
Joined: 14 Apr 2010, 15:59

Conditional formatting OR statement

Post by scottb »

Hello,
I'm trying to get the line right for the following conditional formatting statement and can't get it to work with an OR operator.

If [Labtestresults] are less than [Range1] or if [Labtestresults] are greater than [Range2]

Any help would be appreciated.
Thank you.
-Scott

User avatar
HansV
Administrator
Posts: 78241
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Conditional formatting OR statement

Post by HansV »

Select 'Expression Is' from the dropdown and enter the condition

[Labtestresults]<[Range1] OR [Labtestresults]>[Range2]

S1159.png
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

scottb
4StarLounger
Posts: 402
Joined: 14 Apr 2010, 15:59

Re: Conditional formatting OR statement

Post by scottb »

Thank you Hans. I thought I had tried that but obviously missed something. Much appreciated.