I have a cell in my worksheet that can have 4 alternative entries and I would
like each to be entered using a diferent font colour. Obviously I can't use
conditional formatting as you can only have up to 3 conditions. I have tried
using a lookup list but this only returns the correct entry but does not copy
the font colour.
An example of what I need is as follows:-
Entry Colour
"Rest" Red
"WRD" Green
"Sick" Blue
"Hols" Orange
Any suggestions as to a way round would be gratfully received



--
Al