I would like to set some cells that contain a date to change their font, color, font styles, etc… when the date +6 months has been reached.
Example:
If I set the date in the cell to 8/16/12, then in 6 months from now, I want the date to change to look like 8/16/12 or similar.
Any advice?
Thanks in advance.