I want to highlight whether my “Next Due Date” is in the past or the future , ie. to highlight when the item is overdue. I want the month of my “Next Due Date” to be either red (indicates “Next Due Date” has passed) or green (indicates “Next Due Date” is in the future). See data below:
|BRISBANE – Work Health and Safety||Date of last completion||Required every # months||Next due date||Jan||Feb||Mar||Apr||May||Jun||Jul||Aug||Sep||Oct||Nov||Dec|
|OH&S Policy Branch & Service Manager to read policy and be aware of responsibilities.||14-Nov-17||12||14-Nov-18||0|
I currently have the month of the “Next Due Date” highlighting either red or green. I also want the month to be highlighted red if the year is in the past, or highlighted green if the year is in the future.