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.

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.

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.

That's the point.

You can't apply conditional formating to one cell to affect a different
one.

BUT you can use a different cell when setting up the conditional format
for a cell

So A1 = last week, b1 = this week, c2 = next week

In B13 set up Conditional Format
=IF(b1=this week,1,0)
And set the format accordingly

Steve

On Thu, 25 Jan 2007 06:48:45 -0000, ned wrote:


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.