LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Prabha
 
Posts: n/a
Default Help with Conditional formatting with Dates

Hi there,
I have a spreadsheet in which I have to monitor various dates which are in
different columns (i.e. (1) Date Tender Released, (2) Date Company Selected,
(3) Date Draft Contract Forwarded, (4) Date Contract Signed etc...).

Would if be possible to Conditional Format and have diffirent ROWs
highlighted for each individual Contracts (I have 300 running contracts
running) every time a date is filled in these different columns:

Initial Step (1) = Yellow (Call for Tender released)
Step (2) = Blue (Company Selected)
Step (3) = Brown (Contract under Process)
Step (4) = Green (Contract Signed)

....................Green being the final colour!! :-)

a point to note though: I have already formatted 3 other columns in this
spreadsheet to have the cells change colours once a date is filled in. With
this mean that these CFs would be over-written by the new CFs?

Greatly appreciate you advice!
Prav

 
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 overdue dates Joooooooo Excel Discussion (Misc queries) 1 February 8th 05 11:33 AM
conditional formatting overdue dates Joooooooo Excel Discussion (Misc queries) 1 February 7th 05 01:14 PM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 03:33 PM
Conditional Formatting Dates John Excel Worksheet Functions 11 December 29th 04 08:43 PM
Conditional Formatting for dates spacerocket Excel Worksheet Functions 2 November 4th 04 10:13 AM


All times are GMT +1. The time now is 10:06 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"