How do I set up more than 3 conditional formatting?
in [General]
|
From: Pomodoro on 19 May 2010 05:23 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
From: Gary''s Student on 19 May 2010 06:44 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
From: Pomodoro on 19 May 2010 08:46 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
From: Vicar on 19 May 2010 10:27 .... 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
From: Pomodoro on 19 May 2010 11:04 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
|
Next
|
Last
Pages: 1 2 Prev: Averaging weekly data into Months Next: how do i merge the datas in 2 columns |