View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
rodchar rodchar is offline
external usenet poster
 
Posts: 80
Default can this be done with conditional formatting

thanks for the help everyone,
rod.

"rodchar" wrote:

hey all

i have a single column like the following:

value1
value1
value2
value2
value3
value3

is there a way to do alternating shading of the row based on when the value
changes?

thanks,
rodchar