Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I "grey out" a row in excel | Excel Discussion (Misc queries) | |||
Shades of Grey | Charts and Charting in Excel | |||
grey dot in left upper corner of cell | Excel Discussion (Misc queries) | |||
Grey box | Charts and Charting in Excel | |||
Cell borders printing black instead of grey | Excel Discussion (Misc queries) |