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