conditional formatting dates to change colour

June 14, 2011 at 03:01:58
Specs: Windows 14.02.2010
Hi, i am developing an action task list that I want to change colour as follows. the project is 10 weeks long and I want to macro the cells, such that:
task completed, cell goes green
task within one week of requiring completion, cell goes amber / orange
Task overdue, cell goes red
can you help me do this
I am using Windows 97-2003

See More: conditional formatting dates to change colour

Report •


#1
June 14, 2011 at 10:12:48
Perhaps try reading this post.

http://www.computing.net/answers/wi...

Ask and Answer. The way of learning.


Report •
Related Solutions


Ask Question