How to get the background color from a Conditional Formatting in Excel using VBA
excel, vba
Solution
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.
Problem
I would like to obtain the cell background color assigned using a conditional formatting rule in Excel in my VBA script. I realized that using `Range.Interior.Color` property doesn't have the color resulting of an applied conditional formatting feature from Excel. I did some research and I found this long way here, it compiles and runs but I don't get the assigned color [I get always (255,255,255)] I am using Excel 2016 and I am wondering if there is a simpler way to obtain this information using some built-in VBA function or using any other excel trick.