Interior Cell Colour - Conditional Formatting

  • Thread starter Thread starter michael.a7
  • Start date Start date
M

michael.a7

I have the following UDF that returns the interior cell colour value o
a cell:
Function InteriorColor(CellColor As Range)
Application.Volatile
InteriorColor = CellColor.Interior.ColorIndex
End Function

However, when I use it on a cell that has conditional formatting - an
the formatting is being applied - the result is not the interior colo
value of the conditional format.

Does anyone know of a UDF that will recognise when a cell ha
conditional formatting and give the interior cell colour if th
formatting is being applied?

Many Thanks
 
The easiest way is to replicate the same formula that the cell uses for its
conditional formatting.
 
Back
Top