Whatever any of us come up with, if it's a macro, will simply be a set of
instructions telling Excel what to do in any given situation. That last
part "in any given situation" puts the onus on you. In short, this means
that you MUST clearly define what the different situations are and clearly
define what you want Excel to do in each situation. Things like "you enter
a number less than, equal to, greater than, some value, in some column"
(what column?) Remember that Excel is dumb and has no idea what you want
to happen in each different situation. So you need to decide what all the
possibilities are and what you want to happen for each. HTH Otto