Question

Locked

Conditional formatting with dates

By michvinagre ·
Tags: Software
Please could you assist, I am looking for the formulas for conditional formatting for the following 'headings': Date inspection done, Past Due Date, Future Date (within 3 months), Future date ( 3 Months), Date 2015-2016.
We have inspections we complete on certain dates which is my first column which I input. These inspections need to be carried out every two years (730 days), i am looking for the formula to turn each date a colour as needed above and cannot seem to get it right. Past due date (over 730 days) will be red, Future date (within the next 3 months) will be blue, Future date (after 4 months) will be green and all the dates which go into 2015 can be yellow.
so if the inspection was carried out in 01-01-2012 then it would need to be redone in 01-01-2014 (this has gone past the expired date and needs to be red).
if the inspection was carried out in 01-04-2012 it would need to be done in 01-04-2014 (which will be within the next 3 months so blue.
if the inspection was carried out in 01-07-2012 it would need to be done in 01-07-2014 (which is in the next 4 months and over) so green
if the inspection was carried out in 01-01-2013 it would need to be done in 01-01-2015 and this would fall into the 2015-2016 yellow.
i want the colours in the same column as the inspection dates so we can see at a glance which ones are due.

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums