Hi All,
I've got a couple of date fields like 'Last Meeting', 'Last Phone Call' etc that i'm trying to have coloured based on conditions. The first condition is whether another field have either A, B or C - that field is called 'Target Grade'.
So basically:
If the 'Target Grade' field = 'A' and the 'Last Meeting' or 'Last Phone Call' date is greater than 3 months I would like the date values to turn Red
If the 'Target Grade' field = 'B' and the 'Last Meeting' or 'Last Phone Call' date is greater than 6 months I would like the date values to turn Red
If the 'Target Grade' field = 'C' and the 'Last Meeting' or 'Last Phone Call' date is greater than 12 months I would like the date values to turn Red
Anyone able to get me started?
Thanks, Pri