Conditional Formatting, expression for > X < Y

[David Ball]

Hi,
I am trying to set up conditional formatting to show Green for <1 , Amber for 1 to 14 and Red for anything over 14. I have the expressions as below:
Expression is [Text24] < 1
Expression is [Text24] > 0 <15
Expression is [Text24] <14
The middle expression with > 0 < 15 doesn’t work. How do I represent this in Access conditional formatting?
Thanks very much
Dave

 

[JHB]

The last one is wrong:
Expression is [Text24] <14
Should be:
Expression is [Text24] >14
Post your database, zip it:

 

[isladogs]

Each condition is checked in the order entered so you can use
[Text24] < 1
[Text24] <= 14
[Text24] > 14

 

[arnelgp]

[text24]> 0 and [text24] < 15

 

[David Ball]

Thanks very much

 

[theDBguy]

Hi. I think you can do it with only two conditions if you set the default color to one of the colors you want for one of the conditions. Then, you just need a condition for each of the other two colors.