|This can be done with Conditional Formating (CF) but in Excel 2003, you are limited to 3 CF's per cell. If you need more than 3, you'll need to use a macro.|
To apply up to 3 CF's to a range, follow these steps:
1 - Select the entire range
2 - Choose Format...Conditional Formatting
3 - Cell value...Is equal to...="A"
4 - Click Format...Patterns Tab...Choose a Fill Color...OK
5 - Click Add
6 - Cell value...Is equal to...="B"
The CF will be applied to each selected cell, individually.
In 2010, you can have many more CF's per cell.
If you need more than 3 fill colors, please provide the details and we'll see if we can offer some VBA code (a macro) which will work for you.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.