Conditional formatting by value
I want to show one field in a filled color when the value is greater than another field. What is the syntax that I would use in the field where you indicate "Value is greater than _______"?
You would not. Select the "Formula Is" option instead of "Value Is" and enter a calculation that compares the values of the two fields:
YourTable::Field1 > YourTable::Field2
will specify your selected format for the selected layout object whenever the value of Field1 is greater than Field2.
Thanks Phil- I was hoping it was something silly. Appreciate it-
Retrieving data ...