Use formatconditional formatting (after selecting the cell(s)), formula is
and
=A1DATE(2000,1,1)
click the format button the change the format
to include adjacent cells refer to the same formula but use absolute
references =$A$1DATE(2000,1,1)
where in this case A1 would be the cell you want to highlight
Regards,
Peo Sjoblom
"Rory Carroll" wrote:
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
|