Hi
see your other post

--
Regards
Frank Kabel
Frankfurt, Germany


Craig & Co. wrote:
Hi,

I have a montly on-call roster which is colour coded for each person
on the roster.

I have set it up that if you put a name in the Thursday afternoon
session, it replicates
the name through to the NEXT Thursday morning. HOWEVER, I would like
to also modify the colour of those fields, so that if the person
on-call swaps with another
person, instead of using the Formatter Painter and changing each
group of cells, it
does it automatically.

Something like
IF (E14 = "Bob",
(CELL.Colour="Red",CELL.Text="Bob"),
IF (E14 = "Fred",
(CELL.Colour="Blue",CELL.Text="Fred"),
(CELL.Colour="Green",CELL.Text=E14)
)

I have set the above out as follows
IF
THEN
ELSIF
THEN
ELSE

Any ideas.

Cheers
Craig.