Hi walid66,

If C2 and D2 have formulas in them that are based on the value in B2 they will change. Excel does this best.

If you need to have non-formulas in C2 and D2 and base them on other conditions you can write some VBA code that services the change in an Event Macro.

See http://www.ozgrid.com/VBA/vba-intersect.htm and the On Change Event in http://www.cpearson.com/excel/Events.aspx