Hi all,

I am trying to create a sheet in XL 2010.

In Column F each cell will contain a date (differnet from other cells in that column) when inspection was last done.

Column G is when the weekly inspection is due.

Column H is when bi-weekly inspection is due.

Column I is when monthly inspection is due.

Column J is when 6 monthly inspection is due.

I need a formula to change the colour of cells G, H, I & J when each inspection is due.

I am hoping its possible that the cell colour can stay for 2 days after the due date and then return back to blank after the second day.

For example if cell F3 has a date of January 1 2013 then on January 8 2013 cell G3 turns red then on January 10 2013 the cell returns back to normal.

Thanks