function that returns cell and or font color of another cell
 

is there a cell that returns the numeric d=code for the font or background
color of another cell?

thanks in advance,
mark

function that returns cell and or font color of another cell
 

Chip Pearson's page has an excellent write-up

http://www.cpearson.com/excel/colors.aspx

On May 30, 8:23 am, Mark Kubicki <Mark
wrote:
is there a cell that returns the numeric d=code for the font or background
color of another cell?

thanks in advance,
mark

function that returns cell and or font color of another cell
 

Sub MarkColor()
x = Range("A1").Font.ColorIndex
y = Range("A1").Interior.ColorIndex
MsgBox "Font color is " & x & ", Interior color is " & y & "."
End Sub

"Mark Kubicki" wrote:

is there a cell that returns the numeric d=code for the font or background
color of another cell?

thanks in advance,
mark