Afternoon,

I have a drop down list with five options in cell H3:
Accident Damage
Transferred From
Transferred To
Operational
Service

Now in a seperate cell (L3) I want to use conditional formating so that when
Transferred From is selected, then in the cell it will say "Sending Depot" in
Red and when Transferred To is selected, then the cell will say "Receivig
Depot" in Green.

Any suggestions.

Oh yes, forgot, compliments of the season.