Cond format colour of date...
I am not sure of the format for this cond format -
I want a date field to turn Green, if it is 1 month from today's date, Orange, if it is 6 months, Red, more than a year.. And black if the results of 'another field' is "Yes"...
Also, I am having a few issues re: IF, Else IF, and Else. If I am running a script where I want to Print if Printed field = "No" or if "Yes" then custom dialogue appears...etc etc..bIt of a short brief but can expand if required..