You need VBA for that. Look he
http://www.cpearson.com/excel/events.htm
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"SanPon" wrote in message ...
| Can we change cell B3's value from a condition in say cell A3. I cannot use =
| in B3.
| --
| Ponnath