I have a Gant Chart that works great. It colors a time line based on the dates and type of data (Yellow for leave, Green for training, red for travel.......). However at the start date to each evoution I would like amplifing infomation. Like if travel I would like it to say Where for travel or what type of training. The formula I have works great but since it is in every cell, the data cut off at the column width.
Here is my formula. =if(c2=$f$17,$h$17,if(c2=$f$18,$h$18,if(c2=$f$19,$h$19,if(c2=$f$20,$h$20,"")))) This is copied from colum c thru hh
I'm sure there is a VBA solution that would work if anyone can help.
Here is my formula. =if(c2=$f$17,$h$17,if(c2=$f$18,$h$18,if(c2=$f$19,$h$19,if(c2=$f$20,$h$20,"")))) This is copied from colum c thru hh
I'm sure there is a VBA solution that would work if anyone can help.
