Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
conditional formatting overdue dates | Excel Discussion (Misc queries) | |||
conditional formatting overdue dates | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Conditional Formatting Dates | Excel Worksheet Functions | |||
Conditional Formatting for dates | Excel Worksheet Functions |