I have been racking my brain, basically i would like the result of a calculation to be a certain text colour.
The calculation simply works out how many days between two dates...
Deadline - Get(CurrentDate)
What I would like it to do is colour the result green if over 5 days, orange between 2 and 5 days and red if 2 or under including negatives.
Would much appreciate it if someone could push me in the right direction.