Bordering Groups of Data
Jim,
I applied the formula, not to the entire column, but to the first column of
the rows comprising the range. It had no affect. The range begins at A3, so
I modified the formula to erad = $A4<$A3. It didn't have an affect.
I say all of this with the caveat - I'm not an excel expert by any means.
All of this may be an issue with my limited knowledge of the product.
"Jim Thomlinson" wrote:
I would be inclined to use conditional formatting based on whether the vlaue
in column A changes. Format - Conditional Format - Formula =$A2<$A1
(applied to the entire column)...
--
HTH...
|