Conditional formatting


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
Policy Review
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.




By: Andrew

Leave a Reply

Your email address will not be published. Required fields are marked *