I am trying to get cells to change to a preset colour when a particular 3 digit code is entered. I can get 3 colours using conditional formatting but need to have 6. Is this possible using another formula?? Can anyone help.

Cheers

Jez