Kativa,

You would likely have to monitor a change in event of that cell to determine
the course of action.
--
http://www.ExcelHelp.us

888-MY-ETHER ext. 01781474



"kativa" wrote:

I want to change a value in a cell when autofilter criteria is "all" and if
it isn't then go on to another code. How to do that with ifelse?