How do I set up more than 3 conditional formatting?
 

Hi,
I have 6 different investigation area, one single name each, and I would
like to set 6 different conditional formatting. But I'm not able to set more
than 3.

Any idea how can I manage it?

Many thanks

How do I set up more than 3 conditional formatting?
 

You can use a macro.

What are your conditions / desired formats ??
--
Gary''s Student - gsnu201003


"Pomodoro" wrote:

Hi,
I have 6 different investigation area, one single name each, and I would
like to set 6 different conditional formatting. But I'm not able to set more
than 3.

Any idea how can I manage it?

Many thanks

How do I set up more than 3 conditional formatting?
 

Hi Gary!
Sorry to answer you late, I supposed to receive a notification mail, but I
didn't.
So, my conditions is like this:
if mycellvalue = "Services" then set cell pattern color to red else
if mycellvalue = "Technology" then set cell pattern color to gray else
if mycellvalue = "Green" then set cell pattern color to green else
if mycellvalue = "Service Innovations" then set cell pattern color to orange
else
and so on for at least 6 different Innovation Areas.

--
Pomodoro


"Gary''s Student" wrote:

You can use a macro.

What are your conditions / desired formats ??
--
Gary''s Student - gsnu201003


"Pomodoro" wrote:

Hi,
I have 6 different investigation area, one single name each, and I would
like to set 6 different conditional formatting. But I'm not able to set more
than 3.

Any idea how can I manage it?

Many thanks

How do I set up more than 3 conditional formatting?
 

.... or you could upgrade to Excel 2007 which allows 64 conditions!

"Gary''s Student" wrote:

You can use a macro.

What are your conditions / desired formats ??
--
Gary''s Student - gsnu201003


"Pomodoro" wrote:

Hi,
I have 6 different investigation area, one single name each, and I would
like to set 6 different conditional formatting. But I'm not able to set more
than 3.

Any idea how can I manage it?

Many thanks

How do I set up more than 3 conditional formatting?
 

In my company pcs are still in 2003...
Which is the macro that could help me?
--
Pomodoro


"Vicar" wrote:

... or you could upgrade to Excel 2007 which allows 64 conditions!

"Gary''s Student" wrote:

You can use a macro.

What are your conditions / desired formats ??
--
Gary''s Student - gsnu201003


"Pomodoro" wrote:

Hi,
I have 6 different investigation area, one single name each, and I would
like to set 6 different conditional formatting. But I'm not able to set more
than 3.

Any idea how can I manage it?

Many thanks

I think the version you are using excel 2003. It has limitation to allow only 3 formats maxmium

try this link for vba (macro) help

http://www.ozgrid.com/VBA/excel-cond...ting-limit.htm

all the best

How do I set up more than 3 conditional formatting?
 

Sample worksheet event code for 10 conditions and colors.

Adjust range, vals and nums to suit.

Private Sub Worksheet_Change(ByVal Target As Range)
Set r = Range("A1:A100")
If Intersect(Target, r) Is Nothing Then
Exit Sub
End If
vals = Array("C", "D", "G", "H", "K", "L", "O", "S", "C", "X") 'conditions
nums = Array(8, 9, 6, 3, 7, 4, 20, 10, 13, 15) ' color fill
For Each rr In r
icolor = 0
For i = LBound(vals) To UBound(vals)
If UCase(rr.Value) = vals(i) Then
icolor = nums(i)
End If
Next
If icolor 0 Then
rr.Interior.ColorIndex = icolor
End If
Next
End Sub

This is event code. Right-click on the sheet tab and "View Code".
Copy/paste into that sheet module. Make your edits then Alt + q to return
to Excel.


Gord Dibben MS Excel MVP


On Wed, 19 May 2010 02:23:01 -0700, Pomodoro
wrote:

Hi,
I have 6 different investigation area, one single name each, and I would
like to set 6 different conditional formatting. But I'm not able to set more
than 3.

Any idea how can I manage it?

Many thanks