Conditional formatting using 3 conditions in Macro/VBA

by

Programmatically? Try this:

Sub ApplyConditionalFormatting()

Dim applyto As Range

Set applyto = Range("A2:P236") 'you can make this dynamic

Range("A2").FormatConditions.Add Type:=xlExpression, Formula1:= _
    "=AND($B2="""",$N2=""On Time"",$O2=""Successful"")"
With Range("A2").FormatConditions(1)
    .SetFirstPriority
    With .Interior
        .PatternColorIndex = xlAutomatic
        .Color = 5287936
        .TintAndShade = 0
    End With
    .ModifyAppliesToRange applyto
    .StopIfTrue = False
End With

End Sub

HTH.

More Related Contents:

  1. delete Autofilter Field resullt using the header Name
  2. Somehow it’s not copying [closed]
  3. VBA macro that search for file in multiple subfolders
  4. So, I have 6 “master” files to then divide into 40 separate files
  5. Getting ScriptControl to work with Excel 2010 x64
  6. Application.Match gives type mismatch
  7. Transpose a range in VBA
  8. Protecting cells in Excel but allow these to be modified by VBA script
  9. Saving excel worksheet to CSV files with filename+worksheet name using VB [duplicate]
  10. Using VBA code, how to export Excel worksheets as image in Excel 2003?
  11. How to add a DocumentProperty to CustomDocumentProperties in Excel?
  12. How do I name a spreadsheet automatically, by referencing two cells?
  13. Excel VBA Delete Rows
  14. VBA: How to delete filtered rows in Excel?
  15. Determine whether user is adding or deleting rows
  16. How to use VBA SaveAs without closing calling workbook?
  17. Removing special characters VBA Excel
  18. Excel VBA Formula German/French/Italian/Russian/Dutch/Foreign Function
  19. Iterate over slicer via VBA and select a single item each time
  20. Loop through Excel Sheets
  21. Return a range from A1 to the true last used cell
  22. How to add items to a combobox in a form in excel VBA?
  23. How can I open this VBA workbook faster?
  24. How can I automate Save as dialog box in IE11 using VBA?
  25. How do I avoid run-time error when a worksheet is protected in MS-Excel?
  26. Calling regasm without administrative rights for COM interop in Excel VBA
  27. Is there a way for DIR(path) in VBA to handle strings longer than 260?
  28. How do I activate a specific workbook and a specific sheet?
  29. Start VBA macro when editing a cell
  30. Copy an entire worksheet to a new worksheet in Excel 2010

Leave a Comment