I would like to highlight date cells in a different color which occur for
example after 1/1/2000.

The dates will be all on a colum, some before 1/1/2000 and some after.

In addition to just highlighting the cell itself, is there a way to
highlight adjacent cells.

Any help or pointers would be greatly appreciated.

Regards, Rory