View Single Post
  #1   Report Post  
cjjoo
 
Posts: n/a
Default grouping and give colours


i have a worksheet and teh driver s will key in these information:

date vehicle no km_start km_end distance travelled


at the end of the month, i will do a SORT starting with the vehicle
num. So all the

same vehicle no will be grouped together . Now , i was thinking if it
is possible

to give a alternate colour at each change of the vehicle no.? Can
conditional

formatting help to solve this problem?


--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=474681