Modify Conditional Formatting

Hello Everyone,

Just a quick Question, I have a service schedual, that I would like to manually put in an installation date and a last serviced date, which will then automatically add a date 6 months from that date in the service due box, then 5months into that 6 months I would like the box to highlight yellow, then ounce the 6 months deadline has passed I would like the box to then change to red to indicate it overdue. I have got it almost done with the help of others but it isnt quite working right & I cannot figure out how to change, & what to change to make it right.

And I was also wondering if this will auto update say the date in the box is 1 day before coming into being highlighted yellow, will it change over to yellow when the todays date changes? If not how can I gat it to that please?

Many thanks

Jamiec

Hi Oldchippy,

Many thanks for your reply!!

That goods very good! just what I was after!

Im using 2007, I cant seem to find the same screen as your shot.

Can I do the same in 2007?

Many Thanks

Jamie.c

That would be great! Thanks Again!

Morning Oldchippy,

Mant thanks for your reply looks good thank you!

Just got a few questions, so I can understand thing better, if thats ok.

Does "Today" mean the date put into the "Date last Serviced" cells?
or is it calculating from todays actual date?

As you can see from the example, When the date is put into the "Date last serviced" cell a date 6 months on from that is automatically put into the "service due date" that date may only be for example 2 month away from todays date as it might have been late being put on the system, will that effect the example you have kindly done for me?

And will the conditional format only update the cell colour at the time of inputting the data for that row, and not change colour when the 5months or 6 months time has elapsed? If you know what I mean?

Many thanks, really sorry if they stupid questions!

Jamie.c

Thank you so much for your help!

what is the best way to copy the same to further cells below, ive tried but it seems to add extra conditions!

Many Thanks again

Jamie.c

Thank you!

I have just been playing with the worksheet, putting some data into it, and ive noticed that because some of the data is well back dated if there is a date from say november 2008 which then puts the next service due at may 2009 it doesnt make the cell red as it should do. It the 2008 part mesing it up?

Many thanks

jamie.c

Hi Oldchippy,

No need to opologise I really appreciate the excellent help you have gave me!

Ive attached a copy of the worksheet, I have put in to dates ending in 2008 to show you, the strange thing is the service due date is in 2009, but still the cell has no colour. I tryed changing the date to 2009 and it all works how it should! Strange!

Thank you once again you have been a great help

jamie.c

Good Morning Oldchippy,

Thank you for all your help

Its all works perfect now!!

Jamie.c