Grey cell , or Black cell?

A

Angela1979

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.




Reply Reply to author Forward










Max View profile
More options Mar 7, 2:06 pm

Newsgroups: microsoft.public.excel.worksheet.functions
From: Max <[email protected]>
Date: Wed, 7 Mar 2007 06:06:10 -0800
Local: Wed, Mar 7 2007 2:06 pm
Subject: Re: Grey out cell
Reply | Reply to author | Forward | Print | Individual message | Show
original | Report this message | Find messages by this author
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




- Hide quoted text -
- Show quoted text -

Angela1979 said:
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.





Reply Reply to author Forward Rate this post: Text for clearing
space










Bernard Liengme View profile
More options Mar 7, 2:12 pm

Newsgroups: microsoft.public.excel.worksheet.functions
From: "Bernard Liengme" <[email protected]>
Date: Wed, 7 Mar 2007 10:12:01 -0400
Local: Wed, Mar 7 2007 2:12 pm
Subject: Re: Grey out cell
Reply | Reply to author | Forward | Print | Individual message | Show
original | Report this message | Find messages by this author
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 -
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


:





Reply Reply to author Forward Rate this post: Text for clearing
space










Max View profile
More options Mar 7, 2:21 pm

Newsgroups: microsoft.public.excel.worksheet.functions
From: Max <[email protected]>
Date: Wed, 7 Mar 2007 06:21:00 -0800
Subject: Re: Grey out cell
Reply | Reply to author | Forward | Print | Individual message | Show
original | Report this message | Find messages by this author
Good point, Bernard. Thanks !



- Hide quoted text -
- Show quoted text -

Bernard Liengme said:
To save problems with the last column use
=AND($A2>=B$1,$A2<B$1+7)
best wishes




Reply Reply to author Forward Rate this post: Text for clearing
space










Angela1979 View profile
More options Mar 7, 3:07 pm

Newsgroups: microsoft.public.excel.worksheet.functions
From: "Angela1979" <[email protected]>
Date: 7 Mar 2007 07:07:02 -0800
Local: Wed, Mar 7 2007 3:07 pm
Subject: Re: Grey out cell
Reply | Reply to author | Forward | Print | Individual message | Show
original | Remove | Report this message | Find messages by this
author



- Hide quoted text -
- Show quoted text -
Good point, Bernard. Thanks !
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik
---
- Show quoted text -



.............................................................................­..........................................................................

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




Reply Reply to author Forward










Max View profile
More options Mar 7, 3:13 pm

Newsgroups: microsoft.public.excel.worksheet.functions
From: "Max" <[email protected]>
Date: Wed, 7 Mar 2007 23:13:10 +0800
Local: Wed, Mar 7 2007 3:13 pm
Subject: Re: Grey out cell
Reply | Reply to author | Forward | Print | Individual message | Show
original | Report this message | Find messages by this author
Welcome, Angela.






- Hide quoted text -
- Show quoted text -
You guys are fantastic thanks very much for all your help.




Reply Reply to author Forward Rate this post: Text for clearing
space










Angela1979 View profile
More options Mar 7, 4:16 pm

Newsgroups: microsoft.public.excel.worksheet.functions
From: "Angela1979" <[email protected]>
Date: 7 Mar 2007 08:16:09 -0800
Local: Wed, Mar 7 2007 4:16 pm
Subject: Re: Grey out cell
Reply | Reply to author | Forward | Print | Individual message | Show
original | Remove | Report this message | Find messages by this
author
Welcome, Angela.
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik




- Show quoted text -

#############################################################################

Hi guys,

I'm back again sorry.
With reference to the above another column has now been added - just
when I thought it was complete!
Column D
Contains either BAU or Project.
I need to write if cells D contains Project cell to be black not
grey? I have no idea if this is possible.
 
B

bj

check out conditional formatting in help

Angela1979 said:
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.




Reply Reply to author Forward










Max View profile
More options Mar 7, 2:06 pm

Newsgroups: microsoft.public.excel.worksheet.functions
From: Max <[email protected]>
Date: Wed, 7 Mar 2007 06:06:10 -0800
Local: Wed, Mar 7 2007 2:06 pm
Subject: Re: Grey out cell
Reply | Reply to author | Forward | Print | Individual message | Show
original | Report this message | Find messages by this author
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




- Hide quoted text -
- Show quoted text -








Reply Reply to author Forward Rate this post: Text for clearing
space










Bernard Liengme View profile
More options Mar 7, 2:12 pm

Newsgroups: microsoft.public.excel.worksheet.functions
From: "Bernard Liengme" <[email protected]>
Date: Wed, 7 Mar 2007 10:12:01 -0400
Local: Wed, Mar 7 2007 2:12 pm
Subject: Re: Grey out cell
Reply | Reply to author | Forward | Print | Individual message | Show
original | Report this message | Find messages by this author
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 -







Reply Reply to author Forward Rate this post: Text for clearing
space










Max View profile
More options Mar 7, 2:21 pm

Newsgroups: microsoft.public.excel.worksheet.functions
From: Max <[email protected]>
Date: Wed, 7 Mar 2007 06:21:00 -0800
Subject: Re: Grey out cell
Reply | Reply to author | Forward | Print | Individual message | Show
original | Report this message | Find messages by this author
Good point, Bernard. Thanks !



- Hide quoted text -
- Show quoted text -






Reply Reply to author Forward Rate this post: Text for clearing
space










Angela1979 View profile
More options Mar 7, 3:07 pm

Newsgroups: microsoft.public.excel.worksheet.functions
From: "Angela1979" <[email protected]>
Date: 7 Mar 2007 07:07:02 -0800
Local: Wed, Mar 7 2007 3:07 pm
Subject: Re: Grey out cell
Reply | Reply to author | Forward | Print | Individual message | Show
original | Remove | Report this message | Find messages by this
author
 
T

T. Valko

Try this:

B1:E1 = column header dates

A2:A13 = dates

Select the range B2:E13
Goto the menu Format>Conditional Formatting
Formula Is: =AND($A2>=B$1,$A2<=B$1+6)
Click the Format button
Select the Patterns tab
Select a shade of gray that suits you
OK out

Biff

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.




Reply Reply to author Forward










Max View profile
More options Mar 7, 2:06 pm

Newsgroups: microsoft.public.excel.worksheet.functions
From: Max <[email protected]>
Date: Wed, 7 Mar 2007 06:06:10 -0800
Local: Wed, Mar 7 2007 2:06 pm
Subject: Re: Grey out cell
Reply | Reply to author | Forward | Print | Individual message | Show
original | Report this message | Find messages by this author
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




- Hide quoted text -
- Show quoted text -

Angela1979 said:
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.





Reply Reply to author Forward Rate this post: Text for clearing
space










Bernard Liengme View profile
More options Mar 7, 2:12 pm

Newsgroups: microsoft.public.excel.worksheet.functions
From: "Bernard Liengme" <[email protected]>
Date: Wed, 7 Mar 2007 10:12:01 -0400
Local: Wed, Mar 7 2007 2:12 pm
Subject: Re: Grey out cell
Reply | Reply to author | Forward | Print | Individual message | Show
original | Report this message | Find messages by this author
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 -
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


:





Reply Reply to author Forward Rate this post: Text for clearing
space










Max View profile
More options Mar 7, 2:21 pm

Newsgroups: microsoft.public.excel.worksheet.functions
From: Max <[email protected]>
Date: Wed, 7 Mar 2007 06:21:00 -0800
Subject: Re: Grey out cell
Reply | Reply to author | Forward | Print | Individual message | Show
original | Report this message | Find messages by this author
Good point, Bernard. Thanks !



- Hide quoted text -
- Show quoted text -

Bernard Liengme said:
To save problems with the last column use
=AND($A2>=B$1,$A2<B$1+7)
best wishes




Reply Reply to author Forward Rate this post: Text for clearing
space










Angela1979 View profile
More options Mar 7, 3:07 pm

Newsgroups: microsoft.public.excel.worksheet.functions
From: "Angela1979" <[email protected]>
Date: 7 Mar 2007 07:07:02 -0800
Local: Wed, Mar 7 2007 3:07 pm
Subject: Re: Grey out cell
Reply | Reply to author | Forward | Print | Individual message | Show
original | Remove | Report this message | Find messages by this
author



- Hide quoted text -
- Show quoted text -
Good point, Bernard. Thanks !
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik
---
- Show quoted text -



............................................................................­.........................................................................

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




Reply Reply to author Forward










Max View profile
More options Mar 7, 3:13 pm

Newsgroups: microsoft.public.excel.worksheet.functions
From: "Max" <[email protected]>
Date: Wed, 7 Mar 2007 23:13:10 +0800
Local: Wed, Mar 7 2007 3:13 pm
Subject: Re: Grey out cell
Reply | Reply to author | Forward | Print | Individual message | Show
original | Report this message | Find messages by this author
Welcome, Angela.






- Hide quoted text -
- Show quoted text -
You guys are fantastic thanks very much for all your help.




Reply Reply to author Forward Rate this post: Text for clearing
space










Angela1979 View profile
More options Mar 7, 4:16 pm

Newsgroups: microsoft.public.excel.worksheet.functions
From: "Angela1979" <[email protected]>
Date: 7 Mar 2007 08:16:09 -0800
Local: Wed, Mar 7 2007 4:16 pm
Subject: Re: Grey out cell
Reply | Reply to author | Forward | Print | Individual message | Show
original | Remove | Report this message | Find messages by this
author
Welcome, Angela.
--
Max
Singaporehttp://savefile.com/projects/236895
xdemechanik




- Show quoted text -

#############################################################################

Hi guys,

I'm back again sorry.
With reference to the above another column has now been added - just
when I thought it was complete!
Column D
Contains either BAU or Project.
I need to write if cells D contains Project cell to be black not
grey? I have no idea if this is possible.
 
M

Max

Angela,
Please stay within the same thread.
Keep discussions within the newsgroup for the mutual benefit of all.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top