Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formats using more than 3 conditions
Using Conditional formatting, I can only create up to three conditions. Can
I use formulas or VB code to exceed three conditions? Thanks. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formats using more than 3 conditions
'----------------------------------------------------------------- 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. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Al_Doug" wrote in message ... Using Conditional formatting, I can only create up to three conditions. Can I use formulas or VB code to exceed three conditions? Thanks. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formats using more than 3 conditions
You can use conditional formatting to generate 3 *_formats_*.
Add that to the basic format setting on the cell, and it gives you a total of 4. With a VB event procedure you can have as many formats as you want. But the number of *_conditions_* is another matter. Imagine you want to turn the cell green if any one of 5 conditions are met. You would do: Formula is =OR(condition1,condition2,condition3,condition4,co ndition5) condition1 might be something like B2="hello" does that help? -- Allllen "Al_Doug" wrote: Using Conditional formatting, I can only create up to three conditions. Can I use formulas or VB code to exceed three conditions? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formats don't print | Excel Discussion (Misc queries) | |||
Conditional formatting should allow more than three conditions. | Excel Discussion (Misc queries) | |||
Paste Special Formats Generated by Conditional Formatting | Excel Discussion (Misc queries) | |||
Why do conditional formats appear by themselves in Excel 2003? | Excel Discussion (Misc queries) | |||
how do I apply more than 3 conditional formats in excel | Excel Discussion (Misc queries) |