Conditional Formats

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ned - 25 Jan 2007 05:59 GMT

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.

Reply to this Message

SteveW - 25 Jan 2007 06:19 GMT

Apply a conditional format to that cell, the one 12 below

Refer to the original set of dates.

Steve

> Hi
> I have a row of dates, one week apart and I use the conditional format to
[quoted text clipped - 4 lines]
> Is it possible to do?
> Thankyou.

Reply to this Message

ned - 25 Jan 2007 06:48 GMT

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.

Apply a conditional format to that cell, the one 12 below

Refer to the original set of dates.

Steve

> Hi
> I have a row of dates, one week apart and I use the conditional format to
[quoted text clipped - 4 lines]
> Is it possible to do?
> Thankyou.

Reply to this Message

SteveW - 25 Jan 2007 08:19 GMT

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

> sorry , I didn't explain it right.
> I want to highlight the 12 cells below the highlighted current date.
[quoted text clipped - 18 lines]
>> Is it possible to do?
>> Thankyou.

Reply to this Message