conditional formatting & Icon Set

Dear;

I have a table in excel 2007. this table consist of the following coloms:

Task Name             Start Date      End Date     Status
contact Vendor A     10-Jul-08       19-Jul-08    in-Progress
contact Vendor B     05-Jul-08       12-Jul-08    completed

I want to utilize the new conditional formatting feature (Icon Set) as
follow:
 
IF (End date > Today date) then set a green flag on task name field
else if (End date = Today date  AND Status=in-progress) then set a RED
flag 
on task name field
else if (End date < Today date AND Status=completed) then set a green flag

on task name field

I want to use the built in function Date() for comparison.

how can I do such formula? please help