|
Grey cell , or Black cell?
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 Date: Wed, 7 Mar 2007 06:06:10 -0800 Local: Wed, Mar 7 2007 2:06 pm Subject: 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- - Hide quoted text - - Show quoted text - "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. 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" Date: Wed, 7 Mar 2007 10:12:01 -0400 Local: Wed, Mar 7 2007 2:12 pm Subject: 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 "Max" wrote in message ... - 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 -- 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. 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 Date: Wed, 7 Mar 2007 06:21:00 -0800 Subject: 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 ! -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- - Hide quoted text - - Show quoted text - "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 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" Date: 7 Mar 2007 07:07:02 -0800 Local: Wed, Mar 7 2007 3:07 pm Subject: Grey out cell Reply | Reply to author | Forward | Print | Individual message | Show original | Remove | Report this message | Find messages by this author On Mar 7, 2:21 pm, Max wrote: - Hide quoted text - - Show quoted text - 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. Reply Reply to author Forward Max View profile More options Mar 7, 3:13 pm Newsgroups: microsoft.public.excel.worksheet.functions From: "Max" Date: Wed, 7 Mar 2007 23:13:10 +0800 Local: Wed, Mar 7 2007 3:13 pm Subject: Grey out cell Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author Welcome, Angela. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Angela1979" wrote in message ps.com... - 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" Date: 7 Mar 2007 08:16:09 -0800 Local: Wed, Mar 7 2007 4:16 pm Subject: Grey out cell Reply | Reply to author | Forward | Print | Individual message | Show original | Remove | Report this message | Find messages by this author On Mar 7, 3:13 pm, "Max" wrote: Welcome, Angela. -- Max Singaporehttp://savefile.com/projects/236895 xdemechanik ---"Angela1979" wrote in message ps.com... You guys are fantastic thanks very much for all your help.- Hide quoted text - - 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. |
Grey cell , or Black cell?
check out conditional formatting in help
"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. Reply Reply to author Forward Max View profile More options Mar 7, 2:06 pm Newsgroups: microsoft.public.excel.worksheet.functions From: Max Date: Wed, 7 Mar 2007 06:06:10 -0800 Local: Wed, Mar 7 2007 2:06 pm Subject: 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- - Hide quoted text - - Show quoted text - "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. 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" Date: Wed, 7 Mar 2007 10:12:01 -0400 Local: Wed, Mar 7 2007 2:12 pm Subject: 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 "Max" wrote in message ... - 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 -- 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. 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 Date: Wed, 7 Mar 2007 06:21:00 -0800 Subject: 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 ! -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- - Hide quoted text - - Show quoted text - "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 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" Date: 7 Mar 2007 07:07:02 -0800 Local: Wed, Mar 7 2007 3:07 pm Subject: Grey out cell Reply | Reply to author | Forward | Print | Individual message | Show original | Remove | Report this message | Find messages by this author |
Grey cell , or Black cell?
Try this:
B1:E1 = column header dates A2:A13 = dates Select the range B2:E13 Goto the menu FormatConditional 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 "Angela1979" wrote in message oups.com... 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 Date: Wed, 7 Mar 2007 06:06:10 -0800 Local: Wed, Mar 7 2007 2:06 pm Subject: 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- - Hide quoted text - - Show quoted text - "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. 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" Date: Wed, 7 Mar 2007 10:12:01 -0400 Local: Wed, Mar 7 2007 2:12 pm Subject: 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 "Max" wrote in message ... - 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 -- 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. 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 Date: Wed, 7 Mar 2007 06:21:00 -0800 Subject: 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 ! -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- - Hide quoted text - - Show quoted text - "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 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" Date: 7 Mar 2007 07:07:02 -0800 Local: Wed, Mar 7 2007 3:07 pm Subject: Grey out cell Reply | Reply to author | Forward | Print | Individual message | Show original | Remove | Report this message | Find messages by this author On Mar 7, 2:21 pm, Max wrote: - Hide quoted text - - Show quoted text - 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. Reply Reply to author Forward Max View profile More options Mar 7, 3:13 pm Newsgroups: microsoft.public.excel.worksheet.functions From: "Max" Date: Wed, 7 Mar 2007 23:13:10 +0800 Local: Wed, Mar 7 2007 3:13 pm Subject: Grey out cell Reply | Reply to author | Forward | Print | Individual message | Show original | Report this message | Find messages by this author Welcome, Angela. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Angela1979" wrote in message ps.com... - 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" Date: 7 Mar 2007 08:16:09 -0800 Local: Wed, Mar 7 2007 4:16 pm Subject: Grey out cell Reply | Reply to author | Forward | Print | Individual message | Show original | Remove | Report this message | Find messages by this author On Mar 7, 3:13 pm, "Max" wrote: Welcome, Angela. -- Max Singaporehttp://savefile.com/projects/236895 xdemechanik ---"Angela1979" wrote in message ps.com... You guys are fantastic thanks very much for all your help.- Hide quoted text - - 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. |
Grey cell , or Black cell?
Angela,
Please stay within the same thread. Keep discussions within the newsgroup for the mutual benefit of all. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| All times are GMT +1. The time now is 04:04 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com