Search : in
By :

How to make conditional formating more than 3

Last answer on Jul 21, 2009 12:09:38 pm BST Abel, on Jul 21, 2009 11:21:54 am BST 
 Report this message to moderators

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

Best answers for « How to make conditional formating more than 3 » in :
Unlimited Conditional Formatting ShowUnlimited Conditional Formatting Introduction Principle Code Introduction The limitation of MFC (Conditional Formatting) to Excel version 2007 is less than 3. This is very short. Having seen many applications to push the limit, I am...
Avoid duplicates in Excel ShowAvoid duplicates in Excel In order to avoid duplication when encoding in a column from an excel sheet: take the conditional format on the first cell under the headings (eg A2) choose the following formula:...
Colouring cells on conditions ShowColouring cells on conditions There are many pratical functions under Excel which is not commonly used. Example: If you wish a cell automatically turns red (or other formatting border, frame etc) under one condition: a result, a...
Download AVStoDVD ShowIn most cases, programs offer to convert DVD to other formats more standardized and less bulky. But it is rare to find tools that are the opposite. AVStoDVD is a flexible tool for converting various video formats to DVD format. Advantage The video...
MKV format (Matroska Video) ShowMKV format The MKV format (Matroska Video) is an entirely free video format. More precisely, it is a container (hence the name Matroska, in reference to the Russian dolls contained within another) making it possible to contain video (DivX, Xvid,...
Mini-DIN connector Show4-pin Mini-DIN connector The 4-pin Mini-DIN connector is used for transmitting analog video in S-Video format: More and more graphics cards these days have an S-Video socket built in, so that the computer's output can be viewed on a television...
Managing images in HTML ShowHow do you display images on a web page? Having a few images on a website can make it more attractive and user-friendly. However, it is important not to go overboard, since images can take a long time to load, and in some cases can make a document...

1

 Trowa, on Jul 21, 2009 12:09:38 pm BST

Hi Abel,

I had the exact same problem as you do and here is the answer:
http://translate.google.fr/...

Good luck,
Trowa

Reply to Trowa