If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Possible Conditional Formatting
Using Excel 2003
I have 9 columns A: Last Name B: First Name C: Initial Training D: 6 mo. Training E: 1 Year Training F: 2 Year Training G: 3 Year Training H: 4 Year Training I: 5 Year Training In the intial training column (C) I am going to record a month and year (Mar-10). I want the "6 mo. Training" column (D) to turn (for example) red fill and white font on Sep-10. Then in the "1 Year Training" column (E) to turn (for example) green fill with white font on Mar-11 and so on. How can this be done. Do I have to put a formula in the cells and then apply conditional formatting? The problem is, I can only use up to 3 conditions. Note: Even if I enter the initial training on the day of 3/31/10, I still want the six month to be Sep-10 and so on. How can I accomplish this? ANY help would be greatly appreciated, Karen |
Thread Tools | |
Display Modes | |
|
|