Conditional Formatting - more than 3 conditions

[LinLin]

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!

 

[Sheeloo]

In Excel 2007 you can have more than three conditions but earlier versions
have a limit of three...

What people do is use three conditions through conditional formatting and
three through Cell Formatting (which is much more limited)

 

[JB]

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

 

[JB]

http://cjoint.com/?bvindAD8Gp

JB

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

JBhttp://boisgontierjacques.free.fr

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!- Masquer le texte des messages précédents -

- Afficher le texte des messages précédents -

 

[LinLin]

Merci beaucoup pour la rèponse!

Je suis très heureux!

Vous êtes très gentil .

http://cjoint.com/?bvindAD8Gp

JB

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

JBhttp://boisgontierjacques.free.fr

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!- Masquer le texte des messages précédents -

- Afficher le texte des messages précédents -