How to get the background color from a Conditional Formatting in Excel using VBA

by

If you want to know the color of a cell that has been colored by a conditional formatting rule (CFR) then use Range.DisplayFormat.Interior.Color¹.

If you want to definitively know what color a cell may or may not have been colored by a CFR you need to iterate through the CFRs that could be affecting that cell and look at each of the Range.FormatConditions(*x*).Interior.Color.

Documentation: range.DisplayFormat

¹ Note: .DisplayFormat is not available for a worksheet UDF.

More Related Contents:

  1. to make this code simpler
  2. VBA code takes long time to execute in excel
  3. Excel VBA deleting rows in a for loop misses rows
  4. What is the lifetime of a global variable in excel vba?
  5. Download attachment from Outlook and Open in Excel
  6. What is the most efficient/quickest way to loop through rows in VBA (excel)?
  7. Embed picture in outlook mail body excel vba
  8. How to check for empty array in vba macro [duplicate]
  9. Use autofilter on more than 2 criteria
  10. Excel VBA Load worksheet in Function
  11. Searching an excel with two search words (multiple lookup) using vba macro [closed]
  12. Excel VBA – Combine rows with duplicate values in one cell and merge values in other cell
  13. Load csv file into a VBA array rather than Excel Sheet
  14. Insert line break in wrapped cell via code
  15. Change color of certain characters in a cell
  16. Fastest way to delete rows which cannot be grabbed with SpecialCells
  17. Want VBA in excel to read very large CSV and create output file of a small subset of the CSV
  18. VBA Macro crashes after 32000 rows
  19. Range() vs Cells() vs Range.Cells()
  20. How to create dynamic variable names VBA
  21. How to break a long string into multiple lines
  22. Read VBA macros (or vbaProject.bin) of an Excel file without opening it in MS Excel [closed]
  23. simple vba code gives me run time error 91 object variable or with block not set
  24. Calling regasm without administrative rights for COM interop in Excel VBA
  25. Is there a way for DIR(path) in VBA to handle strings longer than 260?
  26. How do I activate a specific workbook and a specific sheet?
  27. Start VBA macro when editing a cell
  28. VBA Run-time error 438 appears when “paste” runs
  29. If Not function proceeds when value *is* the one specified
  30. Copy an entire worksheet to a new worksheet in Excel 2010

Leave a Comment