i have a inspection chart for machine having every 30 days inspection. for exp if due date is 20-12-2011. iwil perform inspection and i will enter new date that will be 19-01-2012. i wnt cell color pink before one day on due date cell color red. how can i make it.
iam a technician. i have inspetion date cahrt for machine in exel .for exp in coloumn 1 insp A coloumn 2 insp B in colomn 3 insp C.. for these insp a row contain different date. how can i make these date colourd before one day pink and on due date red.example below machine insp 1 insp 2 insp 3 choper 17-12-2011 19-12-2011 25-12-2011 car 01-01-2012 15-01-2012 30-12-2012
Find latest posts