sorry , I didn't explain it right.
I want to highlight the 12 cells below the highlighted current date. these
cells contain text, so I haven't got a date to conditinally format.

"SteveW" wrote in message
news:op.tmo46fioevjsnp@enigma03...
Apply a conditional format to that cell, the one 12 below

Refer to the original set of dates.

Steve

On Thu, 25 Jan 2007 05:59:40 -0000, ned wrote:

Hi
I have a row of dates, one week apart and I use the conditional format to
highlight the current week. I would like to highlight the column 12 cells
below the current date which contain text . I tried numerous things ,but
my
knowledge is limited.
Is it possible to do?
Thankyou.