Can someone help me I have a table that has dates starting from A6 which is a whole month say 01/2/2013 to 28/02/2013 like a gantt template.
I need help if the word "Ordered" is in B5 I need X (crosses) in the date cells starting from B6 to end of month until someone changes B5 to Delivered then I need the X to disappear.
Thanks in advance
mr excel test.xlsm
http://www.excelforum.com/excel-gene...rent-cell.html
http://www.mrexcel.com/forum/excel-q...rent-cell.html
I need help if the word "Ordered" is in B5 I need X (crosses) in the date cells starting from B6 to end of month until someone changes B5 to Delivered then I need the X to disappear.
Thanks in advance
mr excel test.xlsm
http://www.excelforum.com/excel-gene...rent-cell.html
http://www.mrexcel.com/forum/excel-q...rent-cell.html