LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
bec
 
Posts: n/a
Default Automatic Colour Coding on a Row

I want to be able to keep track of a number of incoming documents in excel
and ensure they are actioned within a given timeframe. I want to set up a
simple spreedsheet with columns named: action, date in, date due out.

I want to use colours to identify the urgent requests - ie red for a
document that is within 3 days of its due date, orange for something that is
5 days within due date and green for actions that have greater than 10 days
until its due date.

I assume i need an action for this, but am not entirely sure how..?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional formatting: Colour coding Kelly Excel Discussion (Misc queries) 4 January 18th 06 11:11 AM
Will excel add cells using colour coding eg Add all red cells Wildwoody Excel Discussion (Misc queries) 4 October 21st 05 01:02 AM
Criteria - Automatic Change Font or Fill Colour stevembe Excel Worksheet Functions 4 October 4th 05 04:43 AM
Change Font Colour Automatic When Formula Match stevembe Excel Discussion (Misc queries) 3 October 3rd 05 11:45 AM
Automatic Colour of Cells in Excel SPAGS Excel Discussion (Misc queries) 3 September 3rd 05 04:31 PM


All times are GMT +1. The time now is 02:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"