View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
twaccess[_14_] twaccess[_14_] is offline
external usenet poster
 
Posts: 1
Default Alternate row highlighting with a difference

I get a daily report which I would like to make easier to read b
highlighting each set of row data alternately in different colour
according to the value in the first column

I.e.

a
a
a
a
b
b
b
b
c
c
d
d
d

All the rows where A = "a" would be in grey, then where A = "b", n
colour, then where A ="c" would be back to grey again and so on.

Much appreciate any help or advice available on this.

T

--
Message posted from http://www.ExcelForum.com