Hi all,

My brain hurts from trying to work this one out, I'm no wizard like
most of you on here.
Anyway here's my problem...... hope someone can help.

scheduledreleasedate 14/03/07 21/03/07 28/03/07 04/04/07
09 Jul 07
30 Apr 07
05 Apr 07
01 Apr 07
29 Mar 07
26 Mar 07
16 Mar 07 Grey
16 Mar 07 Grey
16 Mar 07 Grey
16 Mar 07 Grey
15 Mar 07 Grey
08 Mar 07

The dates along the top row are todays date +7days, +14days, +21days,
etc.
I need to ... if the scheduledreleasedate is for example 15 Mar 07 I
would need to put a greyed out cell under the 14/03/07 cell in line
with the 15th March row. Or just write the word grey.

Basically, I need to put a grey cell on the row under the appropiate
date, for example if the scheduledreleasedate is between 14/03 and
20/03 a grey cell would be inserted under the 14/03 column, if the
scheduledreleasedate is 22/03 a grey cell would be inserted under the
21/03 column.

I hope this makes sense to people.
Anything that doesn't please ask.
Thanks everyone for taking time to help.

Select B2:E13 (with B2 active), then apply CF using the formula:
=AND($A2=B$1,$A2<C$1)
Format with gray fill OK out

The above is the CF equivalent to placing this in B2:
=IF(AND($A2=B$1,$A2<C$1),"grey","")
then copying B2 across / down to E13
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


"Angela1979" wrote:

Hi all,

My brain hurts from trying to work this one out, I'm no wizard like
most of you on here.
Anyway here's my problem...... hope someone can help.

scheduledreleasedate 14/03/07 21/03/07 28/03/07 04/04/07
09 Jul 07
30 Apr 07
05 Apr 07
01 Apr 07
29 Mar 07
26 Mar 07
16 Mar 07 Grey
16 Mar 07 Grey
16 Mar 07 Grey
16 Mar 07 Grey
15 Mar 07 Grey
08 Mar 07

The dates along the top row are todays date +7days, +14days, +21days,
etc.
I need to ... if the scheduledreleasedate is for example 15 Mar 07 I
would need to put a greyed out cell under the 14/03/07 cell in line
with the 15th March row. Or just write the word grey.

Basically, I need to put a grey cell on the row under the appropiate
date, for example if the scheduledreleasedate is between 14/03 and
20/03 a grey cell would be inserted under the 14/03 column, if the
scheduledreleasedate is 22/03 a grey cell would be inserted under the
21/03 column.

I hope this makes sense to people.
Anything that doesn't please ask.
Thanks everyone for taking time to help.

To save problems with the last column use
=AND($A2=B$1,$A2<B$1+7)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Max" wrote in message
...
Select B2:E13 (with B2 active), then apply CF using the formula:
=AND($A2=B$1,$A2<C$1)
Format with gray fill OK out

The above is the CF equivalent to placing this in B2:
=IF(AND($A2=B$1,$A2<C$1),"grey","")
then copying B2 across / down to E13
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


"Angela1979" wrote:

Hi all,

My brain hurts from trying to work this one out, I'm no wizard like
most of you on here.
Anyway here's my problem...... hope someone can help.

scheduledreleasedate 14/03/07 21/03/07 28/03/07 04/04/07
09 Jul 07
30 Apr 07
05 Apr 07
01 Apr 07
29 Mar 07
26 Mar 07
16 Mar 07 Grey
16 Mar 07 Grey
16 Mar 07 Grey
16 Mar 07 Grey
15 Mar 07 Grey
08 Mar 07

The dates along the top row are todays date +7days, +14days, +21days,
etc.
I need to ... if the scheduledreleasedate is for example 15 Mar 07 I
would need to put a greyed out cell under the 14/03/07 cell in line
with the 15th March row. Or just write the word grey.

Basically, I need to put a grey cell on the row under the appropiate
date, for example if the scheduledreleasedate is between 14/03 and
20/03 a grey cell would be inserted under the 14/03 column, if the
scheduledreleasedate is 22/03 a grey cell would be inserted under the
21/03 column.

I hope this makes sense to people.
Anything that doesn't please ask.
Thanks everyone for taking time to help.

Good point, Bernard. Thanks !
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bernard Liengme" wrote:
To save problems with the last column use
=AND($A2=B$1,$A2<B$1+7)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

On Mar 7, 2:21 pm, Max wrote:
Good point, Bernard. Thanks !
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik
---



"Bernard Liengme" wrote:
To save problems with the last column use
=AND($A2=B$1,$A2<B$1+7)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email- Hide quoted text -

- Show quoted text -

.................................................. .................................................. .................................................

You guys are fantastic thanks very much for all your help.

Welcome, Angela.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Angela1979" wrote in message
ps.com...
You guys are fantastic thanks very much for all your help.