Within my worksheet which I use to make work roosters for my personel I use
conditional formatting to colour a cell when I enter a particular work code.
For example if I enter K5 in a cell the background colour becomes light
blue and for K14 the cell becomes red. The problem is I can not use
conditional formatting for any more than three colours yet I use up to ten
different codes all of which I would like to have a different coloured
background. Is their a formular or a predefined macro that is available or
has anybody an alternatieve suggestion.
Thankyou in the hope of a positive response.
Mike H