help with conditional formatting

[ashy401]

hi i am new to this site, i am looking for some help with conditional formatting etc. i have vehicles that require services and tests, i want the cell for the particular service to change red when overdue, orange when due within 30days and blank when no data is entered. i would also like a entry at the bottom to count how many are overdue and how many are due.
this is an example of the info i am using
any help would be much appreciated


Service Inspection
vehicle Equip 1 2 3 1 2 3
1 car 23/05/2012 21/11/2012 23/11/2012 23/05/2012 23/05/2012
2 22/11/2012 04/12/2012 05/12/2012 24/01/2013 06/12/2012
3 23/10/2012 24/04/2013 03/06/2013 15/06/2013 15/11/2012

4 bus 26/07/2012 27/02/2013 27/02/2014 12/07/2012 02/08/2012
5 22/11/2012 07/12/2012 20/06/2013 08/02/2013 10/08/2012
6 12/07/2012 11/01/2013 26/01/2013 11/01/2013 21/12/2012
7 23/10/2012 10/11/2012 18/11/2012 10/11/2012 24/10/2012
8 28/08/2012 30/08/2012 30/08/2013 20/02/2013 21/08/2012

[K m]

Perhaps no one responded because you didn't include a workbook. Put the above data in a workbook and attach it to the message

[ashy401]

here is my example workbook attached

[DBY]

Hello
Take a look at the attached file. Does this apply the formatting you're looking for?

DBY

[ashy401]

hi i have allready got the formula for overdue and due within 30days, i would like a formula so that when no data is entered it is blank (no fill). i would also like to know the formula to tally up each red cell at the bottom of each column and same for due in next 30 days.
thankyou

[DBY]

Hello
In my example file the formatting does remain blank if no dates are entered. Without VBA you cannot count cells by colour, but you can count the dates within specified criteria. For the counts you're looking for try the following formulas:

For Red dates:

Please Login or Register  to view this content.

and for Orange dates:

Please Login or Register  to view this content.

Both copied across.

DBY