Hello,
I have a system created in excel for car dispatching and i wanted to assign a color to its car/driver where everytime i enter each name the whole row (e.g A1 to H1) will color it cell to the corresponding color i assigned to it.
I have already use the conditional formating but the problem is that it has its limitation which is 3 condition only and i have more than 3 drivers, so are there any possible commands or formula where we can only entered it in the cell or expand the conditional formating.
Configuration: Windows XP Internet Explorer 7.0
Hi Abel,
|