Conditional Formatting - more than 3 conditions

  • Thread starter Thread starter LinLin
  • Start date Start date
L

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!
 
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)
 
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
 
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....
Click to expand...
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 -
Click to expand...

- Afficher le texte des messages précédents -
Click to expand...
 
Merci beaucoup pour la rèponse!

Je suis très heureux!

Vous êtes très gentil .


JB said:
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....
Click to expand...
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 -
Click to expand...

- Afficher le texte des messages précédents -
Click to expand...
Click to expand...
 
Back
Top