I would like to make a formula so when I enter data for peoples training certifcate expiration dates the cell turns a different color based on if it is expired or not.
For instance if I enter 10-mar-09 it will turn red because it is past due, or if I enter 10-may-10 it will stay green because it is not expired, and last if I enter 29-feb-10 it will turn yellow for almost expired.
Another question if you guys give that , is there a way for it to auto update when ever I open excel? For instance if I where to open it today the date 12-may-10 would be green because it is not expired but say I open it up in summer it would be red.
For instance if I enter 10-mar-09 it will turn red because it is past due, or if I enter 10-may-10 it will stay green because it is not expired, and last if I enter 29-feb-10 it will turn yellow for almost expired.
Another question if you guys give that , is there a way for it to auto update when ever I open excel? For instance if I where to open it today the date 12-may-10 would be green because it is not expired but say I open it up in summer it would be red.