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

thanks in advance,
mark

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

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