I need to specify different text colours for certain conditions. This I can do with the conditional formatting but only for three conditions, I have tried to write some VBA code to allow me to call two or more routines to get more conditions The code only partially works, can anyone tell me where i am going wong, I am sure that this can be done. Code below. Thanks Badger163.
Sub Audit1()
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:="=""no"""
Selection.FormatConditions(1).Interior.ColorIndex = 3
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:="=""?"""
Selection.FormatConditions(2).Interior.ColorIndex = 3
Audit 2
End Sub
Sub Audit2()
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:="=""/"""
Selection.FormatConditions(1).Interior.ColorIndex = 8
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:="=""yes"""
Selection.FormatConditions(2).Interior.ColorIndex = 8
Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlEqual, _
Formula1:="=""n/a"""
Selection.FormatConditions(3).Interior.ColorIndex = 8
End Sub
,
Configuration: Windows XP Internet Explorer 6.0
Conditional formatting between two dates Conditional formatting colour blank cells Conditional formatting column excel based on header Conditional formatting dates excel 2003 across multiple row Conditional formatting match text values Conditional formatting using formulas excel 2008 Conditional formatting using multiple if or and statements and highlighting rows in excel Copying conditional formatting from one cell to multiple cells Excel 2003 conditional formatting more than 3 Excel 2007 conditional formatting different from "previous row" Excel 2007 conditional formatting if cell is equal to and another cell is equal to Excel conditional formatting formula Excel conditional formatting more than 3 Excel conditional formatting row Excel vba conditional formatting Openoffice conditional formatting formula Term and condition format Using if function in conditional formatting