How to make conditional formating more than 3

Abel - Jul 21, 2009 at 06:21 AM
 Trowa - Jul 21, 2009 at 07:09 AM

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.

1 response

Hi Abel,

I had the exact same problem as you do and here is the answer:

Good luck,