Hi. I’m trying to create a format between a range of numbers, for example, any number between 2 -5 will go green with an icon.
however, I’m struggling to get the expression to understand a range: I’ve tried
[Chlorine Free Level (acceptable range is 2 - 5)] = 2,3,4,5
[Chlorine Free Level (acceptable range is 2 - 5)] = 2-5
[Chlorine Free Level (acceptable range is 2 - 5)] = 2:5
What am i doing wrong?
TIA
Solved! Go to Solution.
@Victoria_Winder
Hope I have understood your query correctly:
AND([Chlorine Free Level (acceptable range is 2 - 5)] > 2, [Chlorine Free Level (acceptable range is 2 - 5)] < 5)
However, your searching range and the acceptable range figures are pretty much different than each other.
@Victoria_Winder
Hope I have understood your query correctly:
AND([Chlorine Free Level (acceptable range is 2 - 5)] > 2, [Chlorine Free Level (acceptable range is 2 - 5)] < 5)
However, your searching range and the acceptable range figures are pretty much different than each other.
Thanks, i just edited my question, it should have read “any number between 2-5 will go green with an icon”
@Victoria_Winder
I have updated my expression as such. Hope it helps.
[quote=“LeventK, post:2, topic:11148”]
AND([Chlorine Free Level (acceptable range is 2 - 5)] > 90, [Chlorine Free Level (acceptable range is 2 - 5)] < 180)
[/quote
]
Yes that worked, thanks so much!
You’re welcome
User | Count |
---|---|
32 | |
31 | |
30 | |
19 | |
17 |