Conditional Formatting using Excel VBA code

by

This will get you to an answer for your simple case, but can you expand on how you’ll know which columns will need to be compared (B and C in this case) and what the initial range (A1:D5 in this case) will be? Then I can try to provide a more complete answer.

Sub setCondFormat()
    Range("B3").Select
    With Range("B3:H63")
        .FormatConditions.Add Type:=xlExpression, Formula1:= _
          "=IF($D3="""",FALSE,IF($F3>=$E3,TRUE,FALSE))"
        With .FormatConditions(.FormatConditions.Count)
            .SetFirstPriority
            With .Interior
                .PatternColorIndex = xlAutomatic
                .Color = 5287936
                .TintAndShade = 0
            End With
        End With
    End With
End Sub

Note: this is tested in Excel 2010.

Edit: Updated code based on comments.

More Related Contents:

  1. Duplicate number and it value in column EXCEL [closed]
  2. How to highlight a cell using the hex color value within the cell?
  3. delete Autofilter Field resullt using the header Name
  4. Somehow it’s not copying [closed]
  5. VBA macro that search for file in multiple subfolders
  6. So, I have 6 “master” files to then divide into 40 separate files
  7. Last not empty cell (column) in the given row; Excel VBA
  8. Getting ScriptControl to work with Excel 2010 x64
  9. Application.Match gives type mismatch
  10. Count and Highlight keywords within phrases
  11. Transpose a range in VBA
  12. Protecting cells in Excel but allow these to be modified by VBA script
  13. Saving excel worksheet to CSV files with filename+worksheet name using VB [duplicate]
  14. Detect merged cells in VBA Excel with MergeArea
  15. Excel VBA – QueryTable AfterRefresh function not being called after Refresh completes
  16. Excel VBA: AutoFill Multiple Cells with Formulas
  17. VBA.Find and adding a value
  18. excel vba- extract text between 2 characters
  19. VBA – How the colon `:` works in VBA code with condition
  20. Round function in Excel, worksheet function vs VBA
  21. How to continue the code on the next line in VBA
  22. Excel VBA Userform – Execute Sub when something changes
  23. Count the number of rows in another sheet [duplicate]
  24. Getting Excel to refresh data on sheet from within VBA
  25. VBA Password Input with Cancel Function
  26. Finding first blank row, then writing to it
  27. How can an Excel Add-In respond to events in any worksheet?
  28. VBA inheritance, analog of super
  29. Open Google Chrome from VBA/Excel
  30. Excel VBA Run-time error 1004 when inserting or value formula into cell

Leave a Comment