Conditional formatting.... Excel 2002

Hi,
In Conditional formatting I am only permitted upto 3 Conditions but I
have 6 conditions how may I overcome.

Do later Excel revisions allow for more conditions in Conditional
fromatting?

Thanks
Gunjani

Excel 12 will support unlimited CFs.

You can do it in earlier versions with VBA, such as

Private Sub Worksheet_Change(ByVal Target As Range)
Const WS_RANGE As String = "H1:H10"

On Error GoTo ws_exit:
Application.EnableEvents = False
If Not Intersect(Target, Me.Range(WS_RANGE)) Is Nothing Then
With Target
Select Case .Value
Case 1: .Interior.ColorIndex = 3 'red
Case 2: .Interior.ColorIndex = 6 'yellow
Case 3: .Interior.ColorIndex = 5 'blue
Case 4: .Interior.ColorIndex = 10 'green
End Select
End With
End If

ws_exit:
Application.EnableEvents = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.

or you can try the free add-in CFPlus at
http://www.xldynamic.com/source/xld.....Download.html

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Gunjani" <gunjani786@hotmail.com> wrote in message
news:1139828043.623263.212010@z14g2000cwz.googlegroups.com...
> Hi,
> In Conditional formatting I am only permitted upto 3 Conditions but I
> have 6 conditions how may I overcome.
>
> Do later Excel revisions allow for more conditions in Conditional
> fromatting?
>
> Thanks
> Gunjani
>