Re: $$Excel-Macros$$ conditional formatting- more than 3

2011-10-18 Thread NOORAIN ANSARI
Dear Kuts, Please see attached sheet i hope it help to u Private Sub Worksheet_Change(ByVal Target As Range) Dim icolor As Integer If Not Intersect(Target, Range("A1:A10")) Is Nothing Then Select Case Target Case 1 To 5 icolor = 6 Case 6 To 10

Re: $$Excel-Macros$$ conditional formatting- more than 3

2011-10-17 Thread ashish koul
http://chandoo.org/wp/2008/10/14/more-than-3-conditional-formats-in-excel/ http://en.kioskea.net/forum/affich-21716-conditional-formatting-more-than-3-in-excel On Tue, Oct 18, 2011 at 9:04 AM, Kuts wrote: > Hi > > I am xavier, new to this group. Please help me in conditional > formatting i us

$$Excel-Macros$$ conditional formatting- more than 3

2011-10-17 Thread Kuts
Hi I am xavier, new to this group. Please help me in conditional formatting i use excel 2003 and it does not allow more than 3 conditions. Someone can help please Many Thanks Xavier -- -- Some important links for ex