Nurofen
11-08-2009, 07:34 AM
Hi all,
I'm trying to highlight over due dates but having problems finding the right code to do the job.
In Col E the date is entered manually, depending on the Col B & C from a table Col D is populated with the frequency this will indicate the amount time aloud to passed before my next visit, If the date becames over due I would like it to be highlighted by key colors, also with an option to pass over non-working days Saturday and Sunday if needed between the start date and the visit date.
Thanking you for any help in advance
Regards
Nurofen
I'm trying to highlight over due dates but having problems finding the right code to do the job.
In Col E the date is entered manually, depending on the Col B & C from a table Col D is populated with the frequency this will indicate the amount time aloud to passed before my next visit, If the date becames over due I would like it to be highlighted by key colors, also with an option to pass over non-working days Saturday and Sunday if needed between the start date and the visit date.
Thanking you for any help in advance
Regards
Nurofen