Checking a cell's format in a function

F

FilJ59

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?
 
S

Sheeloo

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top