View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Orlanzo Orlanzo is offline
external usenet poster
 
Posts: 8
Default 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...