Conditional Formatting
 

It would be much simpler if you would shade the cells in
column C using the FormatConditional Formatting menu.
Agreed, you'd have to update this format once a year.

-----Original Message-----
I have a list of equipment that needs to be inspected
every 2 Years in
column "A". In column "B", I enter the date the
inspection was carried out,
as 12/11/01. Column "C" displays the next due date for
the inspection as
12/11/03. I would like in column "D" all inspections
displayed that are due
for inspection for the current year. In this example I
would like to have
the cell in column "D", representing this equipment
shaded in a blue colour.
How would I do this? Any suggestions greatly appreciated.


.