I have been trying to change the colour of a field based on value of a lookup. I am using 0 or 1 as the values.
I have a lookup with 0 or 1 as the field value, i then apply a lookup to give a label like below in a grid:
0 = No
1 = Yes
I am trying to make the value (0 = Red) text and value (1 = Green) text. I see negative values can be formatted but i cant format defined numbers or ranges based on the value.
Also i would like to be able to format dates in particular ranges too, as a visual marker for the users.
I think this would be good as visual markers for users, in this particular situation i have created a Inventory Loan database, where i would like Loans that have not been returned to have a marker/flag to highlight those items.
Many Thanks