conditional formatting - only three options

[Guest]

This is what I am working with.
Field Value is: Less than ([RangMean]-([RangStdDev]*2))-0.002
Field Value is: greater than([RangMean]+([RangStdDev]*2))

If these two conditions are meet the number turns Dark red. But I need two
more statemnts that would calculate outside 3 StDev, then turn red. I only
have one conditional statemnet left to use. Is there some other way to deal
with this?

Can I combine these statemnets in one condition or use expression?
Thank You

 

[Steve Schapel]

Dls,

If both of these conditions result in the same formatting, then yes, you
can combine them, using the 'Expression is...' option:
[YourField]<([RangMean]-[RangStdDev]*2-0.002) Or
[YourField]>([RangMean]+[RangStdDev]*2)

 

[Guest]

This took care of combining these two statments, but now on this same field I
need to have the Result turn bright red when it is outside of 3 StDev (High
or Low). I changed the statment and added to Condition 2. Did not work. Am I
asking for the impossible?
Thank you for your help.

Dls,

If both of these conditions result in the same formatting, then yes, you
can combine them, using the 'Expression is...' option:
[YourField]<([RangMean]-[RangStdDev]*2-0.002) Or
[YourField]>([RangMean]+[RangStdDev]*2)

--
Steve Schapel, Microsoft Access MVP

This is what I am working with.
Field Value is: Less than ([RangMean]-([RangStdDev]*2))-0.002
Field Value is: greater than([RangMean]+([RangStdDev]*2))

If these two conditions are meet the number turns Dark red. But I need two
more statemnts that would calculate outside 3 StDev, then turn red. I only
have one conditional statemnet left to use. Is there some other way to deal
with this?

Can I combine these statemnets in one condition or use expression?
Thank You

 

[Steve Schapel]

Dls,

No, I don't think you are asking the impossible. At this stage I would
guess that "did not work" implies an error with the syntax in the
expression, or a flaw in the logic, or some such. If you post back with
full specific details of your Conditional Formatting setup, someone may
spot the problem.

 

[Guest]

This works: Condition 1 [Results]<([RangMean]-([RangStdDev]*2))-0.002 Or
[Results]>([RangMean]+([RangStdDev]*2)) Turns deep red - which means to us
control outside of 2 SD.
But if this is outside of 3 SD, we would like to flag it true RED. So I
added this statment to the next Condition.
Condition 2 [Results]<([RangMean]-([RangStdDev]*3))-0.002 Or
[Results]>([RangMean]+([RangStdDev]*3))
Only change is "*3". This means the control is out of 3 SD Range.

Hope this helps
Thank You

 

[Steve Schapel]

Dls,

Ah, ok. Well, if it's less than 3 then it is also less than 2, so when
the second condition is true, the first will always also be true, so no
change. Try simply reversing the conditions, i.e. put existing
condition 2 as condition 1 and vice versa - to be honest I am not 100%
sure this will work, but give it a go. If not, we will just have to
write slightly more complicated condition expressions.

 

[Guest]

You are awsome. Anybody told you that.
thank You
dls

Dls,

Ah, ok. Well, if it's less than 3 then it is also less than 2, so when
the second condition is true, the first will always also be true, so no
change. Try simply reversing the conditions, i.e. put existing
condition 2 as condition 1 and vice versa - to be honest I am not 100%
sure this will work, but give it a go. If not, we will just have to
write slightly more complicated condition expressions.

--
Steve Schapel, Microsoft Access MVP

This works: Condition 1 [Results]<([RangMean]-([RangStdDev]*2))-0.002 Or
[Results]>([RangMean]+([RangStdDev]*2)) Turns deep red - which means to us
control outside of 2 SD.
But if this is outside of 3 SD, we would like to flag it true RED. So I
added this statment to the next Condition.
Condition 2 [Results]<([RangMean]-([RangStdDev]*3))-0.002 Or
[Results]>([RangMean]+([RangStdDev]*3))
Only change is "*3". This means the control is out of 3 SD Range.