i need a condition formula that will automatic change the date to red colour when it over 1 week, example today is 22/11/10, if the cell have date 15/11/10 and below will become red colour.
thanks
i need a condition formula that will automatic change the date to red colour when it over 1 week, example today is 22/11/10, if the cell have date 15/11/10 and below will become red colour.
thanks
Last edited by choy96; 11-21-2010 at 11:45 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks