Solved

conditional format, if statement for date range/gannt display

Posted on 2014-01-21
1
232 Views
Last Modified: 2014-01-22
folks

I have an excel sheet with a start and end date column(cell b2/c2),

i.e.

10/1/14 and 20/1/14

i would like colums c to az have the weeknumbers as headings

if within the range from columns d to az the start and finish dates are >= start date and <=
end date then can we highlight the respective rows so it gives us a gantt type view as in  a project plan?

keen for your thoughts                                    


see sample attached
gannt.xlsx
0
Comment
Question by:rutgermons
1 Comment
 
LVL 29

Accepted Solution

by:
IrogSinta earned 500 total points
ID: 39798775
See if this is what you want.  I added conditional formatting using this formula starting from column D.

=AND(D$1>=WEEKNUM($B1),D$1<=WEEKNUM($C1))

Ron
gannt.xlsx
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
iPhone excel activation issues 11 66
time format showing wrong 12 50
Formula 6 45
text replacement instead of two macros only one macro 2 19
Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

919 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now