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
Conditional formatting OR statement
-
- Administrator
- Posts: 78241
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Conditional formatting OR statement
Select 'Expression Is' from the dropdown and enter the condition
[Labtestresults]<[Range1] OR [Labtestresults]>[Range2]
[Labtestresults]<[Range1] OR [Labtestresults]>[Range2]
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 4StarLounger
- Posts: 402
- Joined: 14 Apr 2010, 15:59
Re: Conditional formatting OR statement
Thank you Hans. I thought I had tried that but obviously missed something. Much appreciated.