Solved: schedule using colorfill

[Alvinkiang]

i am almost done with the program but now having a problem. As the user entered the PEM date and PEM duration, it will be able to calculate the schedule date and record it in the pm_track sheets. I have sucessfully done that, but now, i have created a new sheet (JAN). my purpose is to wants the system to be able to fill up the fill on the excel sheet with color according to the schedule date. eg, if the PM Date is 12/12/2006 and the pmDuration is 12, the schedule date calculated wil be 5th of march. so , i wants the system to go into the march sheet and record the equiDID and fill the G5(5th of march) with color.

Hope i have explained clearly what i am trying to do. but i really got no idea how to do it. could Anyone please help mi??? i m not able to attach my project as its too huge. if ur would like to view, i can send it to u personally. thxs.

[ilyaskazi]

From my point of view, i understand that u need code to fill cell color upon qualifying your criteria.

[VBA]
Range("G5").Interior.ColorIndex=6
[/VBA]