Checking a cell's format in a function
 

I am using conditional formatting, and one of my conditions that I would like
to use is to check another cell's fill color and format that particular cell
accordingly. Is this possible?

Checking a cell's format in a function
 

Use an User Defined Funtion to get the Color Index and use that for
Conditional Formatting.

Example UDF
Function GetColorNumber(rng As Range) As Integer
Application.Volatile
GetColorNumber = rng.Interior.ColorIndex
End Function


"FilJ59" wrote:

I am using conditional formatting, and one of my conditions that I would like
to use is to check another cell's fill color and format that particular cell
accordingly. Is this possible?