function that returns cell and or font color of another cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Mark Kubicki - 30 May 2008 15:23 GMT

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

thanks in advance,
mark

Reply to this Message

MDubbelboer - 30 May 2008 15:28 GMT

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
Kubi...@discussions.microsoft.com> wrote:

> is there a cell that returns the numeric d=code for the font or background
> color of another cell?
>
> thanks in advance,
> mark

Reply to this Message

JLGWhiz - 30 May 2008 15:31 GMT

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

> is there a cell that returns the numeric d=code for the font or background
> color of another cell?
>
> thanks in advance,
> mark

Reply to this Message