Assuming dates are in col. A, select col. A., go to
Format Conditional Formatting, Formula Is and put:

=AND($A1=TODAY()-365,$A1<TODAY())

Press the Format radio button and format as desired.

HTH
Jason
Atlanta, GA

-----Original Message-----
I am looking to write a macro that will check for a date
range in a group of
cells (for example: today through one year ago today)
in a worksheet. Then
I would like to highlight the cells that fall within
this date range in bold
red. So far, all I get are syntax errors when trying to
write this macro.
Any ideas?
.