With VBA:

List of Task named Colors:

Work1
Work2
Work3
Holiday
Misc

Color cell depend of string character :

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect([planning], Target) Is Nothing Then
On Error Resume Next
Target.Interior.ColorIndex = [Colors].Find(Target,
LookAt:=xlWhole).Interior.ColorIndex
End If
End Sub

http://cjoint.com/?bvh020SAOP

JB
http://boisgontierjacques.free.fr

On 19 jan, 06:07, LinLin wrote:
Is it possible to do a form of conditional formatting where you have more
than 3 conditions?
I had a quick look through the existing solutions in the discussion group
but I get the impression the answer is no....

And if it is yes, it's not using the Conditional Formatting tool but maybe
VBA?
thanks!