Another Question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kris79 - 24 Feb 2007 20:02 GMT

Is it possible to write an if function on a background color. Say if
a1 has a background color of red return 1 if true and return 0 if
false.

Reply to this Message

Joel - 24 Feb 2007 22:14 GMT

Use this function

Function GetBackgroundColor(Mycell As Range) As Integer
'
' GetBackgroundColo Macro
' Macro recorded 2/24/2007 by Joel
'

'
GetBackgroundColor = Mycell.Interior.ColorIndex
End Function

> Is it possible to write an if function on a background color. Say if
> a1 has a background color of red return 1 if true and return 0 if
> false.

Reply to this Message