Highlighting two fields in a report
Hi I want to be able to highlight when a 'next call back is over due' (Green, Yellow and Red) but if an 'own call back' is checked I want this highlighted in Blue. Both functions work fine separat...
Forum Discussion
If ([Next callback date/time (GMT)]<Now(), "red", [Next callback date/time (GMT)]>Now(), "green", "yellow") - this is what I am currently using and what I am hoping it does is, RED if the next call back is overdue i.e. Not on the day it is due but the day after, Yellow if no 'next call back' date has been entered, and Green if it is up to date i.e. Next call back date hasn't arrived. Hope this makes sense.