Hi, I was wondering if it was possible to change the colour of cells depending on the value. I know I can do it using conditional formatting, but am stuck when I need more than 3 colours. I would like to enter 'r' if a child is in red group, 'p' if a child is in purple group etc...I have 10 colours. Ideally I would like the colour of the letter I have entered to change to the same colour as the background so if I enter 'r' the cell just looks red. Can this be done in Excel 2003?
Thanks, Mrs T.

groups.xls