Compare Dates To Date Range & Return Date Based On Outcome

Ok
Just to make sure everyone knows. I have been searching Array comparison, vlookup and if statements.
But I can't seem to find anything to help me out.

My problem is that I need to compare three cells of random dates shown in Column E, F,& G with Row's H5:AK5, H7:AK7, H9:AK7 (the Dates to these rows is Static on row H3:AK3.)
EX: ROW 5 has Start Date, End Date (1) and End Date (2). Compare Cell H3 between Start Date & End Date (1). If H3 falls between or equal to Start and End Date(1) then highlight cell H5. Proceed till AK3 (higlighting only the cells H5:AK5). Then compare cell H3 between or equal to End Date (1) and End Date (2) (higlighting only the cells H5:AK5)

Then do the same for ROW 7 and ROW 9.

To make things a bit more difficult I need to have " WK#" in Row 14 (these WK# is on another tab called "Task" of the workbook) needs to be displayed in Row's H4:AK4, H6:AK6, & H8:AK8.
EX: Compare Date in D15 between or equal to Start Date & End Date (1) then display Wk# in D14 in H4. Continue till all dates in
D15:Z15 are compared to Start Date & End Date (1) and WK#'s in Row D14:Z14 are inputted if applicable
in Row H4:AK4, H6:AK6, H8:AK8.
I hope this is not confusing.

I can't seem to use the upload option so here is alink to download a jpg of the sheet. I hope it will be readable.

http://i23.photobucket.com/albums/b3...oya/sample.jpg


email: gus.montoya@gmail.com

"This image has been deleted or removed"

Zip and post your workbook, max 100K.

THis is the file I am working on.

Compare Cell H3 between Start Date & End Date (1). If H3 falls between or equal to Start and End Date(1) then highlight cell H5. Proceed till AK3 (higlighting only the cells H5:AK5). Then compare cell H3 between or equal to End Date (1) and End Date (2) (higlighting only the cells H5:AK5)

So is the cell to be highlighted if row 3 is between start and end1 dates, or between end1 and end2 dates, or ???

Cross-posted at http://www.xtremevbtalk.com/showthread.php?t=298285

gusmontoya, please read our Forum Rules.

Originally Posted by shg

So is the cell to be highlighted if row 3 is between start and end1 dates, or between end1 and end2 dates, or ???

That would be Start and end 1

Originally Posted by shg

Cross-posted at http://www.xtremevbtalk.com/showthread.php?t=298285

gusmontoya, please read our Forum Rules.

sorry

I am trying to get help for this. I did not read all the rules since they are so many. But I really need help on this to the point that I will pay someone for the answer.
please help.
Gus

I did not read all the rules since they are so many.

It will take less time for you to read the rules than it will for me or someone else to help with this.

How about you read the rules and post back if you agree, while I look at your spreadsheet?

Hey, Gus,

If you come back, I sorted the conditional formatting, but the other thing isn't clear.