| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format-Expirery date
Hi there,
I have a training schedule for employees columns set up as follows A B C D Employeename DateTrained DateExpires Train Column B is the date they were trained. Column C is B+90 and I would like column D to warn me @ 7 days previous with yellow, and red on the actual day. I would also like it to say "TRAIN" for pivot table purposes. Any advise would be greatly appreciated. Thank you in advance!!!! Sue |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format-Expirery date
Select D2:Dn, wherever it stops.
Menu FormatConditional Formatting Change Condition1 to Formula Is Add a formula of =C2=TODAY() Click Format Select Pattern tab Choose Red OK Click Add button Change Condition2 to Formula Is Add a formula of =AND(C2=TODAY()-7,C2<=TODAY()) Click Format Select Pattern tab Choose Yellow OK What governs the Train, if D is red or yellow? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "smack" wrote in message ... Hi there, I have a training schedule for employees columns set up as follows A B C D Employeename DateTrained DateExpires Train Column B is the date they were trained. Column C is B+90 and I would like column D to warn me @ 7 days previous with yellow, and red on the actual day. I would also like it to say "TRAIN" for pivot table purposes. Any advise would be greatly appreciated. Thank you in advance!!!! Sue |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format-Expirery date
Good point Bob, that would be red. Thank you for the speedy reply!
"Bob Phillips" wrote: Select D2:Dn, wherever it stops. Menu FormatConditional Formatting Change Condition1 to Formula Is Add a formula of =C2=TODAY() Click Format Select Pattern tab Choose Red OK Click Add button Change Condition2 to Formula Is Add a formula of =AND(C2=TODAY()-7,C2<=TODAY()) Click Format Select Pattern tab Choose Yellow OK What governs the Train, if D is red or yellow? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "smack" wrote in message ... Hi there, I have a training schedule for employees columns set up as follows A B C D Employeename DateTrained DateExpires Train Column B is the date they were trained. Column C is B+90 and I would like column D to warn me @ 7 days previous with yellow, and red on the actual day. I would also like it to say "TRAIN" for pivot table purposes. Any advise would be greatly appreciated. Thank you in advance!!!! Sue |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format-Expirery date
In that case also add a formula of
=IF(C2=TODAY(),"Train","") in D2 -- --- HTH Bob (change the xxxx to gmail if mailing direct) "smack" wrote in message ... Good point Bob, that would be red. Thank you for the speedy reply! "Bob Phillips" wrote: Select D2:Dn, wherever it stops. Menu FormatConditional Formatting Change Condition1 to Formula Is Add a formula of =C2=TODAY() Click Format Select Pattern tab Choose Red OK Click Add button Change Condition2 to Formula Is Add a formula of =AND(C2=TODAY()-7,C2<=TODAY()) Click Format Select Pattern tab Choose Yellow OK What governs the Train, if D is red or yellow? -- --- HTH Bob (change the xxxx to gmail if mailing direct) "smack" wrote in message ... Hi there, I have a training schedule for employees columns set up as follows A B C D Employeename DateTrained DateExpires Train Column B is the date they were trained. Column C is B+90 and I would like column D to warn me @ 7 days previous with yellow, and red on the actual day. I would also like it to say "TRAIN" for pivot table purposes. Any advise would be greatly appreciated. Thank you in advance!!!! Sue |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert a month to a quarter ...... | New Users to Excel | |||
| Excel 2007 Date Format Problem | Excel Discussion (Misc queries) | |||
| Conditional format won't copy | Excel Discussion (Misc queries) | |||
| Date Format Problems?? | Excel Discussion (Misc queries) | |||
| Office2000: Conditional format behaves strangely | Excel Discussion (Misc queries) | |||
Hybrid Mode
