LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 21
Default Grey out 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.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I "grey out" a row in excel KLJ Excel Discussion (Misc queries) 7 April 3rd 23 07:30 PM
Shades of Grey Silver Charts and Charting in Excel 2 February 27th 07 10:41 PM
grey dot in left upper corner of cell singnothing Excel Discussion (Misc queries) 1 April 1st 06 10:06 AM
Grey box olofcitifig Charts and Charting in Excel 1 May 6th 05 06:09 PM
Cell borders printing black instead of grey julie@mwfc Excel Discussion (Misc queries) 1 February 23rd 05 12:19 AM


All times are GMT +1. The time now is 02:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"