Hi... like the icon set in conditional formatting .... but do not have a clue how to get it to do what I want... can someone help
My spreadsheet has dates in column F and column G
In column F is the last date the work was done and
In column G is the next date the work is due
I would like column G to show:
a green icon when the date inserted in G is more than 3 months from the date in column F
a yellow icon when the date inserted is within a 3 month span between column F and G
and
a red icon when the date inserted is beyond the date inserted in column G
Thanks.... Excel 2007 or 2010
My spreadsheet has dates in column F and column G
In column F is the last date the work was done and
In column G is the next date the work is due
I would like column G to show:
a green icon when the date inserted in G is more than 3 months from the date in column F
a yellow icon when the date inserted is within a 3 month span between column F and G
and
a red icon when the date inserted is beyond the date inserted in column G
Thanks.... Excel 2007 or 2010