Juan Garcia
-
Posts
3 -
Joined
-
Last visited
Everything posted by Juan Garcia
-
Comment, I used the field BreakfastReading and made it a calculation field. I then tried the formula "Case...... " there. The conditional fix was a perfect fit for me. I also copy/pasted your formula, after taking off the conditional formatting for each field (breakfast, lunch, dinner, bedtime) but it did not work. So I'm sticking with the conditional formatting solution. Thanks...
-
bcooney, Thanks for the conditional fix. Worked like a charm. As for the "if" statement.... yea.... I didn't know how to do that. I could get it to do the If (field) is -> 200; :?? Then I did not know how to get the text color to change to red from black. The conditional thing worked well. I'm happy. Thanks again......
-
I am looking for a way to change the color of text in a field based on a number value. I am a diabetic and when my test result is 200 or more I would like the text to turn red. If it is 199 or less then remain black. I have tried this: Case ( BreakfastReading ≥ "200" ; TextColor ( BreakfastReading ; RGB ( 255; 0; 0 ) ) ) but nothing changes. If it can be done easier please let me know. Any help would be appreciated.