Plotting the Data using vlookup or some other formula

[neer]

Hi Folks,
I've to plot data from one sheet onto another of the same workbook.The tab 'data' has the raw data that needs to be plotted in the tab 'Plot'.I used vlookup and conditional formating to do this till now but I found myself in soup when i had mutiple search keywords using Vlookup as it returned only the first occurence.Kindly suggest me how I can plot mutiple entries in the Data tab onto plot tab.
Eg.
In the 'Data' Tab
# Entry for Task 1 is present for 3 times
A B C D
8 Task1 B7 D7 Black
9 Task1 G7 I7 Black
10 Task1 B6 D6 Green

Cell Start and Cell End is different for each entry with their corresponding Color value.

Required ( In the 'Plot' tab)
The cells starting from B7 to D7 and then G7 to I7 should be filled with BLACK color.
The cell starting from B6 to D6 should be filled with Green color.

I've no idea whether this could be done using formulas or I will have to go for VB( no knowledge of that either ). Your help in any form would be highly appreciated.

Thanks.

 

[neer]

Hello Venkat,
I have tweaked the code a more and have solved the first issue too.
This time I'm checking if the variable 'rrow' is 0 then exit sub cosmetics and go for next filtered rows. This helps to break the 2nd iteration for a single Task entry in the main. But still I am puzzled why the check on variables task,start,eend for NULL or empty did not work?

Well your entire help has certainly fulfilled my desired requirement. I am happy

Thanks for your excellent endeavor.
Cheers