Hi I am trying to establish within a cell to read the date as 20100802 (YYYYMMDD) from this I would like it to automatically change to orange 90 days out, yellow at 60 days out, and red at 30 days out.
Hi I am trying to establish within a cell to read the date as 20100802 (YYYYMMDD) from this I would like it to automatically change to orange 90 days out, yellow at 60 days out, and red at 30 days out.
Last edited by joesport5; 08-02-2010 at 02:57 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks