Excel 2007 : due date condition formula

[pervez]

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.

[Paul]

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Thread Closed.